topic Re: Assigning variable value to a field? in QlikView

Assigning variable value to a field?

divya_anand — Fri, 19 Aug 2016 09:46:24 GMT

Hi,

How do I assign the value of a variable to a field?

The scenario is - I need to Clear the selections made in only Year, Month and Day fields when I move to tab X, and when I move out of tab X the selections that were made when I moved to tab X has to be restored.

For this I am using triggers,

On activation of tab X:

1. Assigning the selections (Getfieldselections()) in Year, Month & Day Field to variables vYear, vMonth and vDay respectively

2. Clearing the selections of Year, Month & Day

On leaving tab X:

1. Assigning the values in vYear, vMonth and vDay to Year, Month & Day fields respectively

This works fine if there was only 1 selection that was made in Year, Month or Day field. But if multiple selections were made, the value that is assigned to the variables are different. for eg. when (Mar, Apr, May, Jun, Jul, Aug, Sep) are chosen in the field Month, the values that is assigned to the variable is (NOT Jan, Feb, Oct, Nov, Dec). Similarly with the Day, when 7 values are chose, (7 of 31) is assigned to the variable instead of (1,2,3,4,5,6,7)

Any suggestions on how I can go about this?

Thank you.

Re: Assigning variable value to a field?

sunny_talwar — Fri, 19 Aug 2016 12:21:06 GMT

I think you need to use the arguments available within GetFieldSelections() function

So something like this:

GetFieldSelections(Month, ',', 10000)

This will ensure that your selections don't turn into nots or 5 of 10000.

Please note: Make sure to increase the max_values accordingly if you have more than 10000 possible selections in the field you are using it for.

Re: Assigning variable value to a field?

Anonymous — Fri, 19 Aug 2016 12:26:38 GMT

Hi Divya,

vYear = If(GetSelectedCount(Year)=0,'',

If(GetSelectedCount(Year) = 1, Year, '('&Concat(DISTINCT Year,'|')&')'))

vMonth = If(GetSelectedCount(Month)=0,'',

If(GetSelectedCount(Month) = 1, Year, '('&Concat(DISTINCT Month,'|')&')'))

vDay = If(GetSelectedCount(Day)=0,'',

If(GetSelectedCount(Day) = 1, Year, '('&Concat(DISTINCT Day,'|')&')'))

Regards!

Re: Assigning variable value to a field?

katharinakostka — Fri, 19 Aug 2016 12:45:54 GMT

Hey Divya!

You could also try alternate states.

Therefor you would put the objects of the different tabs in two different states in order that they simply don't react to each other. That means the selections would not have to be cleared and restored as they only work for the objects in the same state.

Best regards Katharina

Re: Assigning variable value to a field?

divya_anand — Sat, 20 Aug 2016 06:18:38 GMT

This worked perfectly fine for me, just that there was a typo in the expression for vDay (It is suppose to be Day and not Year). I have another question, is it possible to use "," as delimiter? Would it still work? I tried, but doesn't work if I replace "|" with "," in the expression. The reason I'm asking you this is - I would like to see the Selections separated by comma in the "Current Selections" box unlike what I have now (Refer to the snapshot below)

Thank you very much.

Re: Assigning variable value to a field?

sunny_talwar — Sat, 20 Aug 2016 23:29:35 GMT

Although I am glad you got what you wanted, but I am not sure if you tried what I proposed. Should have been an easier alternative, unless you like to complicated stuff

Re: Assigning variable value to a field?

divya_anand — Sun, 21 Aug 2016 13:59:30 GMT

Hi Sunny,

I tried this on the first hand, dint work for me. When I make more than 1 selection in Year/Month/Day, and when I open tab X and switch to a different tab, everything was getting deselected.

Re: Assigning variable value to a field?

Anonymous — Mon, 22 Aug 2016 06:04:42 GMT

Hi Divya, for select you have to use '|' instead ',' on vars.

Regards!