Advertisements

Handy tool, Excel-SQLizer/

https://github.com/DeliciousPie/Excel-SQLizer/releases

Advertisements

combine NT security with user name and password #qlikview section access

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

 

Call stored procedure Oracle ODBC

Use

SQL CALL

https://community.qlikview.com/thread/12849

Oracle in OraClient 12Home2, #Qlikview, and case of field names capitalization

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

Dynamic Variable #Qlikview

set vNewVariable = $(vTestName);

let ‘$(vNewVariable)’ = ‘Something’;

RDP session for keepass

This is very nice way to add RDP sessions to keepass

http://www.nullsec.us/opening-rdp-sessions-from-keepass/

Amazing whitepaper on QVD structure

http://qlikview.oxs.ru/install/Goods/QVDocumentation/Enterprise%20Framework/Scalability/Data%20Management/QlikView%20Enterprise%20QVD%20Layer.pdf