Discussion Board for collaboration related to Creating Analytics for QlikView.
I have some few questions:
Lets assume i have two tabs:
Tab 1: Includes my hidden script
Tab 2: Includes all my dimensions and facts
Now i want to create section access based on some values from a dimension. Here i got some problems understanding how it relates to my dimension.
Lets take my hiddenscript tab:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, OptionText
admin, admin, admin, *
user, hans, 1234, Open
user, gert, 1234, Closed
It looks like this:
I want hans to see Open and gert to see only Closed.
Optiontext is from my Dimension: DimSalesStatus
which looks like this:
SQL SELECT *
My questions is then - How should my section access script really look like to filter on open and closed for gert and hans?
and then what?
Go to Solution.
to implement section access we need to have common dimension in both section access and section application.
and both field names and values should be in capital letters.
and you need to enable intial data reduction based on section access option in document properties on opening tab.
see the attached file