Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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"
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"
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?
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...)
Ok was my mistake, thanks a lot.