Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

two list box in one sheet

hello friends

my boss asked me to make a sheet in which there are two tables with the same field(for example NetSalesAmount). but they are different in time period(and this differential is not a static one). in fact he wants to be able to set time period for each of tables and compare them. do you know how it is possible?

thanks

mana

1 Solution

Accepted Solutions

Re: two list box in one sheet

Yes it is, take a look to alternate states, set it in the Settings -> document properties -> general

with the button alternate state and apply it in objects you need

Let me know

3 Replies

Re: two list box in one sheet

Yes it is, take a look to alternate states, set it in the Settings -> document properties -> general

with the button alternate state and apply it in objects you need

Let me know

Not applicable

Re: two list box in one sheet

Hi mana,

You can achieve this using alternate state concept, PFA qvw which contain alternate state example.

Thanks !!!

Not applicable

Re: two list box in one sheet

This is only possible by Alternate state,Got o settings-> document properties,click on alternate state and add two state there State1 and State2.

then go to your one list box and set its alternate state state1 and go to your table properties and set its alternate state as State1 now this two objects are related to each other selection of this list box only reflected by this table.

do the same for second list box and table and set their state as State2.document properties.pngalternate state.png