topic Alternate States question in QlikView

Alternate States question

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i have a question about Alternate States, i have a List box that is in 'StateB', this obviously doesnt filter when other selections are made in other list boxes. does anyone know of a way this can be done?

eg.

if i have list boxes for...

Product Group

Product Category

Product

and Product is in StateB and the rest are in the default state, then i want Product to still respond to selections made from the other 2 List Boxes..

i have attached a QVW

thanks in advance

Re: Alternate States question

kaushiknsolanki — Mon, 12 Dec 2016 10:07:58 GMT

Hi,

That is what is the Alternate State, which means a selection of one set shouldnt change the selection of other set.

If you want the selections to be made, then simple make then part of the same group (Set).

Regards,

Kaushik Solanki

Re: Alternate States question

adamdavi3s — Mon, 12 Dec 2016 10:08:44 GMT

Yes it is possible to do this, I would suggest maybe using a couple of field triggers and the 'copy states' action... this one is sneaky as it only appears when you actually have an alternate state defined...

or maybe an expression in the listbox, I'll pull something together

Re: Alternate States question

swuehl — Mon, 12 Dec 2016 10:09:05 GMT

If you want to filter the list box, but keep the selections in different states, you can try a field expression like

=Aggr(Only({$}Product),Product)

Re: Alternate States question

adamdavi3s — Mon, 12 Dec 2016 10:11:33 GMT

Beat me to it!

Re: Alternate States question

hopkinsc — Mon, 12 Dec 2016 10:14:00 GMT

thanks Stefan!