Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Awesome. Thank you.
yes it can be done with alternate states.
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.
yes you can possible
write the below condition
sum({<Product=>}Sales)
write the below for other expressions
sum(sales)
Awesome. Thank you.