topic Re: Variable in App Development

Variable

Frédéricdh — Mon, 17 Jun 2024 13:31:38 GMT

Hello,

I crete an Button where I set a variable like this REF = 26222

and in the script i write this REFNUM = $(REF) but it doesn't work, the srcipt don't find a value or the REFm why?

Re: Variable

marksouzacosta — Mon, 17 Jun 2024 14:01:57 GMT

Would be nice to see exactly what you do have typed in your Load Script and what do you have on your UI. I'll give you an example:

The first Action of this button set the value of a variable vRunningTask:

These are the variables in the Variables window:

And this is how I called in the Load Script:

You are probably missing something in your Load Script. How are you setting your variable? What is the code? I believe it should be something like:

SET REFNUM = '$(REF)';

Re: Variable

Frédéricdh — Tue, 18 Jun 2024 08:42:08 GMT

I define my Variable like that:

AND in MY SQL, I use the variable like that

WHERE

XBRA.XBREFNUM = $(REF)

If i write this '$(REF)', Qlikview use it like a string, no?

Re: Variable

marksouzacosta — Tue, 18 Jun 2024 12:54:54 GMT

Try XBRA.XBREFNUM = $(Ref) instead.

Qlik is case sensitive. That is why it is not finding REF (uppercase).
Regarding your question, yes, if you use single quotes, it will be considered strings otherwise will try to use it as a numeric value. If it is numeric, you are good.

Re: Variable

Frédéricdh — Wed, 19 Jun 2024 06:39:12 GMT

No it doesn't work

😞