topic Re: Qlikview Alternate state in QlikView

Qlikview Alternate state

deepakqlikview_123 — Tue, 02 Feb 2016 10:00:36 GMT

Hi All,

PFA.

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

Thanks,

Deepak

Re: Qlikview Alternate state

sunny_talwar — Tue, 02 Feb 2016 10:04:32 GMT

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

Re: Qlikview Alternate state

swuehl — Tue, 02 Feb 2016 10:07:26 GMT

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

Re: Qlikview Alternate state

deepakqlikview_123 — Tue, 02 Feb 2016 10:08:26 GMT

Hi Sunny,

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

Thanks,

Deepak

Re: Qlikview Alternate state

deepakqlikview_123 — Tue, 02 Feb 2016 10:09:28 GMT

we need same functionality in file by using alternate state

Thanks.

Re: Qlikview Alternate state

sunny_talwar — Tue, 02 Feb 2016 10:10:25 GMT

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?)

Re: Qlikview Alternate state

Anonymous — Tue, 02 Feb 2016 10:10:43 GMT

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

Re: Qlikview Alternate state

sunny_talwar — Tue, 02 Feb 2016 10:12:27 GMT

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?

Re: Qlikview Alternate state

swuehl — Tue, 02 Feb 2016 10:14:41 GMT

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.

Re: Qlikview Alternate state

swuehl — Tue, 02 Feb 2016 10:17:23 GMT

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.