Use
SQL CALL
https://community.qlikview.com/thread/12849
Filed under: Uncategorized | Leave a comment »
Oracle in OraClient 12Home2, #Qlikview, and case of field names capitalization
Posted on April 26, 2018 by mellerbeck
This was an annoying one for a bit.
Say you have this Qlikview script
LOAD
Sales_Order
;
Select ORDER_NUMBER as Sales_Order from…. ;
Well, it won’t work because the Oracle ODBC driver uppers all the returned field names, or Oracle does? Who knows?
Anyways, to make it work
LOAD
SALES_ORDER
Filed under: Uncategorized | Leave a comment »
Dynamic Variable #Qlikview
Posted on April 16, 2018 by mellerbeck
set vNewVariable = $(vTestName);
let ‘$(vNewVariable)’ = ‘Something’;
Filed under: Uncategorized | Leave a comment »
RDP session for keepass
Posted on March 21, 2018 by mellerbeck
This is very nice way to add RDP sessions to keepass
http://www.nullsec.us/opening-rdp-sessions-from-keepass/
Filed under: Applied IT, Uncategorized | Leave a comment »
Amazing whitepaper on QVD structure
Posted on March 6, 2018 by mellerbeck
Fix #Qlikview 12.2 DirectConnect stopped working, Database connection failed
Posted on January 4, 2018 by mellerbeck
Upgraded to 12.2 and through web clients I was getting a Database connection failed. Checked the error log and it was complaining about not being able to find
fileNotFound C:\Program Files\QlikView\Server\QvConnect64.EXE) occurred during open of C:\Program Files\QlikView\Server\QvConnect64.EXE
Well, I think the installer possibly didn’t place it correctly? Anyways, to fix it just copy
C:\Program Files\QlikView\QvConnect64.EXE into the Server folder C:\Program Files\QlikView\Server\ and then the magic works again
Filed under: Uncategorized | Leave a comment »
Weird one for you, left handed mouse through RDP, how to fix
Posted on December 1, 2017 by mellerbeck
Install the microsoft Intellipoint driver and it will auto switch it for you when you connect to the terminal server.
Filed under: Uncategorized | Leave a comment »
