topic two list box in one sheet in QlikView

two list box in one sheet

Wed, 10 Sep 2014 08:56:16 GMT

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

Re: two list box in one sheet

alexandros17 — Wed, 10 Sep 2014 09:02:52 GMT

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

Re: two list box in one sheet

Wed, 10 Sep 2014 09:16:33 GMT

Hi mana,

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

Thanks !!!

Re: two list box in one sheet

Wed, 10 Sep 2014 09:26:48 GMT

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.