Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Choose only a product on a sheet and all on the other one

Hello,

¿It is possible to have on a sheet a table with all products and on another sheet a graph that show only 1 product?

i attach a sample qwd.

thank you

6 Replies
martinpohl
Partner - Master
Partner - Master

so change your expression on tab 2 to

sum({<Product={x}>} KPI)

to show only Product x

Anonymous
Not applicable
Author

but i would like to choose on the filter the different products

martinpohl
Partner - Master
Partner - Master

than change the listbos field to expression and use

=if(Product='x',Product)

ben_pugh
Creator
Creator

Hi Pablo. I think the answer here is to use alternate states. There's a good guide here if you're not familiar with them:

what is alternate states in Qlikview ?

m_woolf
Master II
Master II

You can use the sheet OnActivate and/or OnLeave events to make selections and clear them when the user goes from one sheet to another.

Anonymous
Not applicable
Author

Easiest way is Ben's response on alternate state.  Easy to make different sheets use different states.