topic Previously selected cyclic group value in QlikView

Previously selected cyclic group value

Wed, 18 Jun 2014 10:07:45 GMT

Hi All,

In the context of cyclic group, we can find out the current selected group value through "GetCurrentField(cyRegion)" .

But Is there any way to find out previously selected group value?

Re: Previously selected cyclic group value

Gysbert_Wassenaar — Wed, 18 Jun 2014 11:33:45 GMT

There's no getpreviousfield() function. I think the only way is to use bookmarks with the option Include Layout State enabled.

Another thing you can try is create a table in the script with a field that contains the fieldnames you now use in the group. You can use the listbox to select a fieldname and use that value as dimension name for your chart. Now you can get the previous selection with =only({$1}Field). See attached example.

Re: Previously selected cyclic group value

Wed, 18 Jun 2014 12:44:35 GMT

Hi Gysbert,

I am storing the Current value in Variable1 by using below expression:

Variable1

=MinString

(

If(GetCurrentField(cyRegion)='VCC',VCC_CUR,

If(GetCurrentField(cyRegion)='COMP2',COMP2_CUR

))

)

Variable1 changes at every selection.

Now I want to store the previously calculated value in Variable 2.

Re: Previously selected cyclic group value

Gysbert_Wassenaar — Wed, 18 Jun 2014 12:46:11 GMT

The answer is pretty much the same. Either use bookmarks and enable to option to include variable values in the bookmark or use a field like I did in my example.

Re: Previously selected cyclic group value

Thu, 19 Jun 2014 05:07:27 GMT

That means I have to apply the trigger on Change Event of variable 'Variable1' to add bookmark and extract the previous value using bookmark name.