Qlikview Alternate state

[deepakqlikview_123]

Hi All,

PFA.

Can you please suggest how to achieve functionality provided in sheet by using alternate state.

Thanks,

Deepak

[sunny_talwar]

Which part of the attached qvw are you trying to accomplish using Alternate State?

[swuehl]

Would be maybe easier if you tell us the required functionality.

[deepakqlikview_123]

Hi Sunny,

It would be better by using both of list boxes for selection in table.

Thanks,

Deepak

[deepakqlikview_123]

we need same functionality in file by using alternate state

Thanks.

[sunny_talwar]

Stefan I think I know what he is trying to do. He wants to move the whole chart and the triggers to alternate state. Is there a alternate state equivalent of $1 (previous selection)? May be like AS1 (where AS is the name of alternate state?)

[Anonymous]

Check this?

First create Two States:

Document Properties -> Alternate States(Top Right) -> Add -> State1 and State2

Then whichever object you want to put in States:

Goto Object Properties -> General -> Top Middle -> Inherit States -> State1 or State2

[sunny_talwar]

I think the issue is that we can move all the objects and things to the alternate state, but trigger contains this:

=if(GetSelectedCount([Color])<>0 and Concat({$1} Distinct [Color],'"|"')<>Concat({1} Distinct [Color], '"|"'),

'("'&Concat({$1} Distinct [Color],'"|"')&'"|"'&Concat(Distinct [Color],'"|"')&'")',

if(GetSelectedCount([Color])<>0,'("'&Concat(Distinct [Color],'"|"')&'")')

)

How can we move the bold part to alternate state?

[swuehl]

I would probably rather go with a checkbox style in list box properties, rather doing with trigger'ed field selection what I think he's doing.

[swuehl]

Sunny, if you want to play around, I don't think there is an equivalent to $1 for alternate states, but you can try using a variable to store the previous selection content for the field.