topic Re: Re: Set field from variable in QlikView

Set field from variable

Fri, 17 Jan 2014 17:06:47 GMT

I want to save the selections in a field upon entering sheet1. Then I want to manually change the selections in that field. Then upon leaving sheet1 I want to restore the original selections that I saved.

I tried this by GetFieldSelections and storing the result in a variable. These are years by the way. This results in a comma separated list. Then I change the years to what is appropriate for Sheet1. Then when I leave sheet1 I want to put the original list of years that I saved back into the field. I tried doing this by taking the comma separated list, adding leading and trailing parentheses and replaced the commas with pipes.

This doesn't work. Does anyone have any suggestions? Maybe a better way to be able to restore the values?

Re: Set field from variable

Gysbert_Wassenaar — Fri, 17 Jan 2014 17:19:09 GMT

Create a bookmark per sheet and use the OnLeave and OnActivate sheet triggers to save (replace) the bookmark when leaving the sheet and activating the bookmark when entering the sheet.

Re: Set field from variable

iktrayanov — Fri, 17 Jan 2014 17:29:46 GMT

So this (2010|2011|2012) does not work

Try to make your search string like this (*2010*|*2011*|*2012*)

Re: Set field from variable

Fri, 17 Jan 2014 17:38:26 GMT

Thanks that works. I'm also going to try Ivan's solution to see if that will let me restore only certain fields.

Re: Set field from variable

Fri, 17 Jan 2014 17:49:18 GMT

Ivan, my search string was as you supposed. I changed it as you suggested, but it didn't work. When I go back to another sheet all years are de-selected.

Re: Re: Set field from variable

iktrayanov — Fri, 17 Jan 2014 17:57:40 GMT

You may want to double check how you set your actions. It should work.

See the attached example. I created a button SetVariable that holds your selections and after changing selections another button Select that selects your saved selections. Take a look at the actions.

Re: Set field from variable

Fri, 17 Jan 2014 18:21:59 GMT

Hi Ivan,

It partially works. Once the variable starts displaying things like "All" or "Not A" it no longer works. I added a few rows to your example to test this out. Is there a way to fix this? By the way, the difference between your suggestion and what I did originally was I used "$" in front of the variable name to expand it, which didn't work. Once I saw that you didn't have a "$" in your example, I took it out and it worked, up until the variable displayed things like Not A.

Re: Set field from variable

iktrayanov — Fri, 17 Jan 2014 18:33:05 GMT

Can you attach your example?

Re: Re: Set field from variable

Fri, 17 Jan 2014 18:37:23 GMT

This is your example with a few more rows. If I select say, all rows except A, set the variable, then make a different selection and then click Select, it doesn't use the variable.

Re: Re: Set field from variable

iktrayanov — Fri, 17 Jan 2014 18:44:29 GMT

Sorry I know what the problem is.

I was trying something else and I forgot to remove the triggers. Go on the document properties and remove the triggers from Prod1 also go on the Select button and change the field from Prod1 to Prod2.

Re: Re: Re: Set field from variable

Fri, 17 Jan 2014 18:51:32 GMT

I did as you suggested and the problem still remains. I appreciate the time you've been putting into this. I've attached my altered version of your example.

Re: Re: Re: Set field from variable

Fri, 17 Jan 2014 18:57:58 GMT

I think I found the problem. There is a default value of 6 on GetFieldSelections for how many values it will display. So if I increase the maximum above 6, your example works. Also, you can put the pipe directly in the GetFieldSelections function. I'm going to try it on my actual data. Hopefully it will work. Thanks again.

Re: Set field from variable

jerem1234 — Fri, 17 Jan 2014 20:18:15 GMT

You could use the concat function instead, this way you dont have worry about setting the max.

='('&concat(Prod2, '|')&')'

Hope this helps!