Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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.