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

 

Advertisements

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’;