Background filter

[schmidtj]

Hi,

i was wondering if it is possible in Qlik Sense to set a filter for selected charts which cannot be changed by the viewer.

My problem is, that i have certain KPIs on my sheet which are supposed to show a value for certain dimensions only.

Would be glad for some advice.

Cheers.

[Anonymous · Accepted solution]

I think you need set analysis.  If your chart expression is

sum(Amount).

and you want only Country='Sweden' and Product='Qlik', it will be

sum({<Counrty={'Sweden'},Product={'Qlik'}>} Amount)

Read more in "help"

[schmidtj]

Hi,

thanks a lot, this is working so far.

However i have a more complicated issue with filtering an aggregation in my chart.

I have the following example - data model is designed as a star schema:

Dimensions:

- Role

- User

- Categorie

Fact:

- Number of tickets

My goal is to show a bar chart with the user names on the x-axis and the number of tickets on the y-axis.

However, per user i only want to show the number of tickets where the user has the role 'Role X'.

If i do a set analasys like this for a certain user it shows me the right results for that user:

[ROLE]={'Tester'}, [USER]={'JOHN DOE'},

But i want to show all users - only who have the role 'Tester'.

If i remove the user-filter the numbers are not right.

Any idea how i would write the analisys?

[Anonymous]

So, you have now a chart with dimension USER and expression

sum({<ROLE={'Tester'}>} "Number of tickets")

And you say that numbers are wrong.  Can you check if the numbers are right if instead you use the expression

sum("Number of tickets")

and select manually Tester?

(I can't see the reason why it could be different...)

[schmidtj]

Ok was my mistake, thanks a lot.