topic Re: Alternate State Possible Selection in QlikView

Alternate State Possible Selection

Tue, 03 Mar 2015 09:03:15 GMT

Hi to all,

I Have Two Alternate State "State1" and "State2" i have assigned it for the required list box..but if i select the Field call State i need to get the POSSIBLE Value for the Selected value in the alternate state list box..How can i get this...Pls its Urgent....

Re: Alternate State Possible Selection

Gysbert_Wassenaar — Tue, 03 Mar 2015 09:25:05 GMT

I'm afraid I don't understand what you're trying to do. Can you post a qlikview document that demonstrates the problem?

Re: Alternate State Possible Selection

Tue, 03 Mar 2015 10:13:52 GMT

i have attached the sample format PFA

Re: Alternate State Possible Selection

Gysbert_Wassenaar — Tue, 03 Mar 2015 10:24:05 GMT

So you want the alternate states to behave exactly as the default state? Then remove the alternates states and assign the default state to the two listboxes.

Re: Alternate State Possible Selection

Tue, 03 Mar 2015 10:31:11 GMT

Hi,

Use P() and E() in set analysis

p(sum({state1} sales))

P() --- it will give possible records

E() -- it will give excluded records

Re: Alternate State Possible Selection

Tue, 03 Mar 2015 10:47:30 GMT

i am using this Scnerio for Comparison So its must in alternate state...then only user can compare both the values for analysis...

Re: Alternate State Possible Selection

Tue, 03 Mar 2015 10:48:46 GMT

i need to filter in list box.not in the Charts.