Chart Question

[#1]

Here is a screen shot of my dashboard:

What I would like to do is have the team make a selection in both the State and Product List Boxes.  The Total Clients all Products I want the condition to be based on the State Selection only.  The other two charts I want the condition to be based on State and Product selection.  Is this possible?

David

[sundarakumar]

yes it can be done with alternate states.

[Nicole-Smith]

If you want the Total Clients all Products to not use the Product selection, you need to put {<Product=>} in your set analysis.  For example:

count({<Product =>} Client)

This tells QlikView to ignore any selections in Product for this calculation.

[preminqlik]

yes you can possible

write the below condition

sum({<Product=>}Sales)

write the below for other expressions

sum(sales)

[#5 · Accepted solution]

Awesome.  Thank you.