Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sculptorlv
Not applicable

How to use SET - simply

Can't get with simple thing. Please help.

I defined one variable

SET Price_Criteria = '2.84';

Now I opened Text Object ... and use following value:

=$(Price_Criteria)  

     and I get no values....

How can I use my simple variable?

1 Solution

Accepted Solutions
reddys310
Not applicable

Re: How to use SET - simply

Hi Ruslans,

Just use this as your expression : =$(Price_Criteria) .... this will work

11 Replies
stalwar1
Not applicable

Re: How to use SET - simply

What do you get when you just do =Price_Criteria in the text box?

jpe
Not applicable

Re: How to use SET - simply

Either way worked for me ??  Maybe save, close , reopen qlik sense desktop? (if server, close browser)

Capture.PNGCapture2.PNG

sculptorlv
Not applicable

Re: How to use SET - simply

uh... for me this not working..

may be it is about qlickview vesion - I have version 10.

1_Set.jpg

2_Result.jpg

sculptorlv
Not applicable

Re: How to use SET - simply

I get the wrong variable and no result

3_Result.jpg

stalwar1
Not applicable

Re: How to use SET - simply

If you are seeing this, my guess is that your variable is not getting created. Can you check and confirm that you are able to see your variable in the variable overview (ALT + CTRL + V)

reddys310
Not applicable

Re: How to use SET - simply

Hi Ruslans,

Just use this as your expression : =$(Price_Criteria) .... this will work

jontydkpi
Not applicable

Re: How to use SET - simply

Works for me, although you don't need the $ expansion, putting

=Price_Criteria


or

=$(Price_Criteria)

should work just as well.

sculptorlv
Not applicable

Re: How to use SET - simply

Thanks. This really works. I used to use exactly this syntax  - but there was problem and I found it out.

At the very beginning I used SET variables ant the start of my SQL text. Then  I copied (cut) them to the end of SQL text and add another SET variables.

The old ones worked, but new ones DON'N. Thus I copied ALL SET variables at the beginning of my SQL. Now everything works fine.

sculptorlv
Not applicable

Re: How to use SET - simply

Uh.. this syntax.. what I do wrong now???? Please help

This simple formula..

2.jpg

And it doesn't work in expression:

1.jpg