Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
tuxo9999
Contributor II
Contributor II

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
Partner

so change your expression on tab 2 to

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

to show only Product x

tuxo9999
Contributor II
Contributor II
Author

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

martinpohl
Partner
Partner

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.

atkinsow
Specialist II
Specialist II

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