Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need some help regarding section access. I am able to restrict access via section access script , certain section of filter panes and data
for example SALES USER A can only see a total of a 105 customersID, instead of the full total 1000 customersID
she can for example only choose too, country USA from a filter pane (Country) and Kitchen from filter pane (Department)
however I would like SALES USER A to be able to compare her sales to everyone else in the system. so still see 1000 customersID, BUT still have the restriction of the filters she can choose
please help
You could get this if you are loading your data twice. One time normal like now with your section access implemented and one time without any section access whereby you replaced your dimension-values with random one (not to identify and changing with every reload) and/or to consolidate those data to a higher level which then only return an average of your KPI's and these could be then compared against the restricted data.
- Marcus
Hiya
is there a sample app that can be downloaded to explain help with this issue on qlik community please?
please help
No, I haven't a sample. For years I had have implemented one with consolidated data and the logic for it is quite simple, like:
AveragePerMonth:
Load Month, Year, sum(Sales) / count(distinct customersID) as AvgSales
From YourTable Group By Month, Year;
- Marcus