Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

j_schmidt
Contributor

Background filter

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.

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Background filter

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"

4 Replies
mov
Esteemed Contributor III

Re: Background filter

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"

j_schmidt
Contributor

Re: Background filter

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?

mov
Esteemed Contributor III

Re: Background filter

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...)

j_schmidt
Contributor

Re: Background filter

Ok was my mistake, thanks a lot.