Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have created a report in qlikview with all user's entry-exit times to show them how many hours they work and how many hours they have delay per month, now I wanna publish the report in our sharepoint portal but each of them is suppose to see just her/his report, means when they log in with their usernames and password, the report has to show just those information which is related to them . I made a list in sharepoint (as you can see in the picture) which user's access information and add the below script part in my report script , but it doesnt work did I miss s.th?
Thanks
PersonelInfo:
LOAD * INLINE [
RowNumber,PersonelId,ows_Author
1,9,9;#Mohsen Kermani
2,10,10;#Mehdi Etehadi
3,13,13;#Mis Bahrami
4,30,30;#Mis Shahi
5,38,38;#Mis Aqabeyki
];
AccessInfo:
LOAD ows_NTNAME as NTNAME,
ows_SAUSER as SAUSER,
ows_TABACCESSSHEET1 as TABACCESS.SHEET1,
ows_TABACCESSSHEET2 as TABACCESS.SHEET2,
ows_FIELDACCESSDIVISIONFILTER as FIELDACCESS.DIVISIONFILTER,
ows_Title as ACCESS
FROM [http://10.130.11.3/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={1D93957E-BD48-428A-B599-3F2D811982C3}&View={61BFBA78-3020-4081-B475-FA0EDBBB944D}] (XmlSimple, Table is [xml/data/row]);
Section Access;
SATABLE:
LOAD
ACCESS,
NTNAME,
SAUSER
Resident AccessInfo;
Section Application;
DocSecurity:
LOAD
SAUSER,
TABACCESS.SHEET1,
TABACCESS.SHEET2,
FIELDACCESS.DIVISIONFILTER as PersonelId
Resident AccessInfo;
Have you enabled Initial Data Reduction Based On Section Access in Document Properties : Opening ?
Also, if you want those stars to work (I assume they are to mean "everything"?), you need to put
STAR is *;
before loading the DocSecurity table. Otherwise it will look for users who have literal stars as their PersonelID.
It is prudent to put
STAR is;
right after loading this table, to turn it off again (it will remain in effect for already loaded data).
Hi Jakub ,
Yes , due to my searches for sloving my problem I have enabled Initial Data Reduction Based On Section Access in Document PropertiesmOpening tab and also I added STAR is * in the right place but it still doesnt work ! I think there is something about table relations or like this . and it's interesting that the filter seems to work when a user run the report exe file , but any effect when try to open it on the web ! how they can be different?!
Do you mean the Section Access works when opening qvw app in the QlikView desktop locally, but doesn't when opening it on the Access Point? That would be very strange. Just to be sure, by not working you mean just the filter not working, not the app failing to open at all on the Access Point?
Hi Jakub
Yes I mean just the filter not working.