topic Re: Change alternate state with button action in QlikView

Change alternate state with button action

Anonymous — Tue, 24 Nov 2015 07:22:20 GMT

Good day!

Dear colleagues, in my model i have some pivot. it has default alternate state.

Also i have one button. Is there any way to add some action function for this button, which will change alternate state for this pivot, for example, for STATE1?

Thanks.

Re: Change alternate state with button action

swuehl — Tue, 24 Nov 2015 07:29:52 GMT

I don't think you can directly change the state of chart via a button action, but you can create several charts in different states and use a variable to show / hide these charts. Control this variable in your button action.

Re: Change alternate state with button action

jagan — Tue, 24 Nov 2015 07:40:21 GMT

Hi,

It is not possible to change the state of the sheet or objects dynamically, instead you can dynamically use the expression like below

=If(vStateName = 'State1', Sum({[State1]} Sales), Sum(Sales))

Hope this helps you.

Regards,

jagan.

Re: Change alternate state with button action

vincent_ardiet — Tue, 24 Nov 2015 07:48:45 GMT

You can also avoid the IF.

Put in vStateName either $, or [State1]...

Then you expression will be:

=Sum({$(vStateName)} Sales)

Re: Change alternate state with button action

Mark_Little — Tue, 24 Nov 2015 08:43:01 GMT

Hi,

Swuehl's approach is how i always approach this kind of thing

Mark