Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

permissions from xls table

I have module thet get the Permissions for user from SQL Tbl, i used with section access & section Application .

i have to convert my Sql tbl to Xls Tbl (load the tbl from xls) .

when i add the section access & section Application to the loadind from xls it's failed.

but if i commete it it's work fine but i must have this lines.

i copy my code:

from sql- work fine:

ODBC CONNECT TO SQL (XUserId is bbb, XPassword is yyy);

Section Access;
  LOAD ACCESS,
      NTNAME,
     DEPT;
  SQL SELECT *
  FROM bbb.d.QlikviewSec;
Section Application;
LOAD DEPT,
    PATH;
SQL SELECT *
FROM aaa.d.UserDept;

from Xls-not working:

SECTION Access;
LOAD [ACCESS],
     NTNAME,
     DEPT
FROM
C:\bbb.xls
(biff, embedded labels, table is sheet1);

SECTION Application;
LOAD DEPT,
     PATH
FROM

C:\aaa.xls
(biff, embedded labels, table is sheet1)

tnx for healping!

10 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Still not fixed? I guess something else is wrong. Could you post your QVW, or at least a limited copy (with data) that still isn't working? That would make analysis a lot easier.

Luck,

Peter