topic Re: Alternate State - Need to copy selection from default state to Alternate State in QlikView

Alternate State - Need to copy selection from default state to Alternate State

nramirez — Wed, 24 Sep 2014 23:44:33 GMT

I have a couple selections that the user will make and need to capture those selections and apply them to an alternate state.

Does anybody have any insight or some demo's I might be able to take a peak.

Thanks in advance.

Re: Alternate State - Need to copy selection from default state to Alternate State

simenkg — Thu, 25 Sep 2014 00:09:58 GMT

If you create a button or a text box, under Actions - Selections there is an action called "Copy state content". This can also be used as a trigger on activate sheet.

Re: Alternate State - Need to copy selection from default state to Alternate State

Anonymous — Thu, 25 Sep 2014 00:30:31 GMT

Hey Nestor,

In case you are trying to achieve in an expression, this might be helpful using set analysis.

Considering you have an Alternate State as "STATE A";

=sum(<[STATE A]{<Year = $ :: Year>})>} Sales)

This will get the Year selected from the defalut state to your Alternate State.

Hope I have made a point.

Thanks,

Vijit

Re: Alternate State - Need to copy selection from default state to Alternate State

nramirez — Thu, 25 Sep 2014 16:37:26 GMT

Simen,

I have been struggling with the "source state" and the "target state". Can you help me filling it out.

I have my default state under "TOP 10 Customers" screen shot, and what I'm trying to do is every time the user clicks on a particular ORDERACCOUNT I want to have a trigger copy the selections from the default state and apply them to the "Booked" alternate state.

I believe my target State statement is wrong or possible the entire idea could be a little off.

Any help would be greatly appreciate it.

See screen shoots below.

Re: Alternate State - Need to copy selection from default state to Alternate State

simenkg — Fri, 26 Sep 2014 07:10:12 GMT

Source state: $

Target State : Booked

Re: Alternate State - Need to copy selection from default state to Alternate State

Anonymous — Thu, 17 Nov 2016 16:32:00 GMT

Not working 🙂

Re: Alternate State - Need to copy selection from default state to Alternate State

Anonymous — Thu, 17 Nov 2016 17:49:23 GMT

sum({[Booked] < ORDERACCOUNT*=$::ORDERACCOUNT >} yourvalue)