topic Re: Section access and set Analysis issue in QlikView

Section access and set Analysis issue

alec1982 — Tue, 28 May 2013 21:20:57 GMT

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

rustyfishbones — Tue, 28 May 2013 21:43:57 GMT

Create 3 Dimensions and Conditionally show based on Section Access

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

rustyfishbones — Tue, 28 May 2013 21:46:25 GMT

This video I created on YouTube may help