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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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