https://github.com/DeliciousPie/Excel-SQLizer/releases
Advertisements
Filed under: Uncategorized | Leave a comment »
combine NT security with user name and password #qlikview section access
Posted on April 27, 2018 by mellerbeck
The trick is in the *
You can add reducing fields after the NTNAME
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, NTNAME
ADMIN, ADMIN, welcome, *
USER, *, *, DOMAIN\USERNAME
];
Section Application;
From https://community.qlik.com/thread/29846
Filed under: Uncategorized | Leave a comment »
Call stored procedure Oracle ODBC
Posted on April 26, 2018 by mellerbeck
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
