topic Re: Select in Field Issue with Variable in QlikView

Select in Field Issue with Variable

jjking58 — Wed, 25 Nov 2020 16:16:04 GMT

I'm experiencing a problem using the select in field with a variable that hopefully someone can help me with.

I set the variable on "OnOpen" (image 1) then do a select in field (image 2) just below it.

The variable is getting updated to "3" but the condition of selecting "902" is never met.

Any help would be greatly appreciated.

Thanks in advance.

Re: Select in Field Issue with Variable

Anil_Babu_Samineni — Mon, 11 Dec 2017 17:00:41 GMT

Does variable updates from Input Box somewhere? Or how does it is. Can you please share sample.

Re: Select in Field Issue with Variable

jjking58 — Mon, 11 Dec 2017 17:04:14 GMT

the variable value is coming from a file loaded in the section application load of the section access

Re: Select in Field Issue with Variable

Anil_Babu_Samineni — Mon, 11 Dec 2017 17:06:51 GMT

Can you place second argument to first and first to second like

If(vRep=3, '(' & 901 & '|' & 902 & ')' , 902)

Re: Select in Field Issue with Variable

jjking58 — Mon, 11 Dec 2017 17:14:49 GMT

OK, I switched them and then tested. The 902 value works, but the (901|902) does not. Is it possible the variable is not loading until after the select in field?

Re: Select in Field Issue with Variable

Anil_Babu_Samineni — Mon, 11 Dec 2017 17:23:33 GMT

Well, May be i need to test. I wonder why it is not. For a while (901 | 902) try this alone. Let's see, I assume with If .. Else condition should work. Let me get for you by tomorrow. It's late night ..

Re: Select in Field Issue with Variable

jjking58 — Mon, 11 Dec 2017 17:24:38 GMT

Thanks

Re: Select in Field Issue with Variable

Anil_Babu_Samineni — Tue, 12 Dec 2017 12:32:50 GMT

For me Its' working

Re: Select in Field Issue with Variable

tresB — Tue, 12 Dec 2017 12:48:09 GMT

Action sequence could be causing the issue. So to make it sure that the selection triggers works only when the variable value has been set, instead of putting the second action (selection) under same OnOpen trigger, try putting it under Variable Event trigger.