Discussion Board for collaboration on QlikView Scripting.
I need to set up user access, so
LOAD * INLINE [
ACCESS, NTNAME, SALESPERSON, COUNTRY
ADMIN, ADMINISTRATOR, *, *
USER, USER1, VIGGO, *
USER, USER2, JOHAN, *
USER, USER3, ANNIE, *
USER, USER4, HAKAN, *
USER, USER5, PIOTR, *
USER, USER6, HELEN, *
USER, QLIKUSER, VIGGO, SWEDEN
USER, QLIKUSER, *, FINLAND
USER, QLIKUSER, *, NORWAY
The result is that QLIKUSER can see all records in Finland and Norway... and Sweden!!! He should seet only Viggo's records in Sweden but he sees all records for the rest of users.
Is the desired data reduction possible in Qlikview?
Many thanks in advance!
Go to Solution.
Well, with some help from our partner we have what we wanted. Hidden script:
FROM Reductions.xls (biff, embedded labels, table is Security$);
STAR IS *;
FROM IReductions.xls (biff, embedded labels, table is Reduction1$);
FROM Reductions.xls (biff, embedded labels, table is Reduction2$);
The Reductions.xls file looks like this:
Thanks to you all who helped me!
You could try loading it from an excel file. Put the details in an excel file then load it like this.
upper(SALESPERSON) as SALESPERSON,
upper(COUNTRY) as COUNTRY
(ooxml, embedded labels, table is Sheet1);
Can you attach your script in data model which has Salesperson and Country fields? Your datamodel should have this fields then it will automatically restricts.