Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

nicklisterman
Contributor

Alternate state parent filter?

I'm calculating ticket volume differences (count of tickets in state A minus state B) in a bar chart (inherited state) based on week selections made in alternate states.  I now want to apply a selection for specific products but the alternate states don't appear to limit to the product select box (inherited state).  Am I doing something wrong?

1 Solution

Accepted Solutions
jerem1234
Valued Contributor II

Re: Alternate state parent filter?

You'll have to add some set analysis to your expressions, so that they listen to the product selection in the inherited state. Something like:

sum({State1<Product=$:Smiley Tongueroduct>}Tickets)

Find attached for an example.

Hope this helps!

2 Replies
jerem1234
Valued Contributor II

Re: Alternate state parent filter?

You'll have to add some set analysis to your expressions, so that they listen to the product selection in the inherited state. Something like:

sum({State1<Product=$:Smiley Tongueroduct>}Tickets)

Find attached for an example.

Hope this helps!

nicklisterman
Contributor

Re: Alternate state parent filter?

That immediately worked.  Thank you!

Community Browser