Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Section access and set Analysis issue

Hi Guys,

I have a dashboard that shows data for 3 clients and I have section access to show data for each client per their users. this is working perfect.

I have a table within the dashboard that shows some fields and as I have the three clients I see all their data in it.

the reason it is not filtering is because I have set Analysis in it as follow: Sum({1}[Sales])

What should I put instead of the {1} in order to fix it and each client will see only their data.

Thxs,

Alec

2 Replies
rustyfishbones
Master II
Master II

Create 3 Dimensions and Conditionally show based on Section Access

Or

Create 3 Expressions and Conditionally based on Section Access

So in the below Image you can see, the Expression for the last 30 days will only show if the Range.Analysis =3

You can create a condition to do the same using Section Access

Range.png

rustyfishbones
Master II
Master II

This video I created on YouTube may help

https://www.youtube.com/watch?v=LimUIy164d4