topic Section Access for NTuser different behaviour in desktop and Web version in QlikView

Section Access for NTuser different behaviour in desktop and Web version

Thu, 24 Nov 2011 07:12:15 GMT

Hi,

i am writng an section access to hide and show sheets

in my script editor, it looks like following :

for the sheet i set the show sheet conditional like this :

It works fine in my Qlikview desktop version. But when i put it to Qlikview Web Access, It does'nt work well after i press clear all button. You can c before and after i clear the Clear All button. and i suspect that something to do with the selection?

Before

After

How come like this? and any solution to achieve hide and show that good fit with Qlikview Web Access?

I appreciate you can suggest me the best way for achieving it.

Best Regards,

Jeffrey

Section Access for NTuser different behaviour in desktop and Web version

SunilChauhan — Thu, 24 Nov 2011 10:15:53 GMT

on documeent properties did u check intial data reduction based on section access

and uncheck strict exclusion

instead of writing Sh12 <>0 u can write count('Sh01')>0

Section Access for NTuser different behaviour in desktop and Web version

Tue, 29 Nov 2011 04:59:06 GMT

Thank for your reply. i have enable that option.

But when i change the sheet condition to ur syntax : write count('Sh01')>0, it seen no working.

Section Access for NTuser different behaviour in desktop and Web version

johnh — Tue, 29 Nov 2011 07:35:44 GMT

Hi Jeffrey On the Doc Settings Opening tab tick the Initial Data Reduction Based on Section Access not the Initial Selection Based on Section Access.

Then your syntax of SH12<>0 would also work.

Be very carefull when unticking the Strict Exclusion. If it is unticked and there is no data in the model for the user to see the user will be shown all the data instead of being denied access to the document! By default the ADMIN user opens the model with Strict Exclusion "unticked" ie if they cannot see any data they see all data. However if you are opening the model via the web there is no such thing as a ADMIN user. All users have an access type of USER.