topic Re: Alternate State - Passing Multiple State at once to Base state (Inherited state). in QlikView

Alternate State - Passing Multiple State at once to Base state (Inherited state).

Mon, 03 Aug 2015 16:18:05 GMT

Hello Team,

i have to pass the selection made in list box which are in different Alternate states,

on button Action to a chart.

Ex:

in the above screen, i have 2 Alternate state (State -1 an State - 2) and a Straight table which is in Inherited state.

if I select Status from State - 1 & click on Apply - Ac1 , the a Straight table which is in Inherited state has filtered the records based on the Status selected in State - 1 (i have used Copy state content action ).

next, if i Select Category as 2 in State - 2, and click on Apply - Ac2 then the Straight table should show only the record which has Status as "In Evaluation" & Category as "2". but i am not sure how to achieve this.

if i click on Apply - AC2, it is filtering only category 2 records. as show in the below screen.

I need to carry forward both the alternate state as filter. attached qvw file.

Need help on this.............

Re: Alternate State - Passing Multiple State at once to Base state (Inherited state).

Gysbert_Wassenaar — Mon, 03 Aug 2015 16:45:31 GMT

Perhaps this video tutorial helps: Using Alternate States to Select Multiple Values in a List Box with Different Attributes

Re: Alternate State - Passing Multiple State at once to Base state (Inherited state).

Tue, 04 Aug 2015 03:44:23 GMT

Thanks gwassenaar

but i am having more number of fields used as filters in each states...hence i am looking some thing like "copy state content" trigger at once. also, i need to captured existing applied state content.

the state1 selection is override by another state selection.

pls, find the attached sample qvw file. where it is overriding ! state1 selection after another state selection is made.

Re: Alternate State - Passing Multiple State at once to Base state (Inherited state).

Gysbert_Wassenaar — Tue, 04 Aug 2015 05:58:46 GMT

I don't understand why you need two alternate states in the first place. You simply makes selections in two fields and the result should be the records that meet both selections. You don't need alternate states for this at all.

Re: Alternate State - Passing Multiple State at once to Base state (Inherited state).

Wed, 05 Aug 2015 14:45:08 GMT

Hello Gysbert,

I got the requirement, like below.

in the state 1, i made few selections & apply that selection to the charts. i need to drill down with further selection made in State 1 by applying the selection made in State 2.

in between , if i am not satisfied with selection made in State 2 ...i need to cancel the selection made in Sate2 & retain the selection made in State1.

any help on this .....will be help full

Thanks & regards

Rajashekar

Re: Alternate State - Passing Multiple State at once to Base state (Inherited state).

Gysbert_Wassenaar — Wed, 05 Aug 2015 15:16:33 GMT

There's a button in the toolbar to move back (and forward) through selections you've made earlier.