topic Re: Qlik Sense: How to create a variable that can be used at front end? in QlikView

Qlik Sense: How to create a variable that can be used at front end?

dineshsingh — Mon, 22 Dec 2014 11:02:07 GMT

Please suggest a way to create variables without calling generic objects API.

Re: Qlik Sense: How to create a variable that can be used at front end?

Gysbert_Wassenaar — Mon, 22 Dec 2014 11:16:37 GMT

Create them in the Data load editor:

SET vMyVariable = 1;

Then reload the document.

Re: Qlik Sense: How to create a variable that can be used at front end?

dineshsingh — Mon, 22 Dec 2014 11:39:02 GMT

Thanks Gysbert,

Can we use LET instead of SET in case when we have to first evaluate expression?

Re: Qlik Sense: How to create a variable that can be used at front end?

Gysbert_Wassenaar — Mon, 22 Dec 2014 11:40:01 GMT

Yes, you can use LET too.

Re: Qlik Sense: How to create a variable that can be used at front end?

engishfaque — Mon, 22 Dec 2014 11:54:23 GMT

Dear Dinesh,

SET => Just assign value to the variable as a literal.

LET => First Evaluate the expression and then assign to variable.

Kind regards,

Ishfaque Ahmed

Re: Qlik Sense: How to create a variable that can be used at front end?

dineshsingh — Mon, 22 Dec 2014 12:24:26 GMT

I got problem in using LET. I have described my problem in the image above, please help me.

Re: Qlik Sense: How to create a variable that can be used at front end?

Gysbert_Wassenaar — Mon, 22 Dec 2014 12:33:57 GMT

The expression only(Date) is meaningless in the script. It will evaluate to Null and that means the variable won't exist after the script is finished. Perhaps you want to create a variable in the script containing the expression Only(Date) and you want to use that in the front end. If so you need to use SET instead of LET: SET vSelectedDate = Only(Date);. You can then create a measure to use the variable: =$(vSelectedDate)

Re: Qlik Sense: How to create a variable that can be used at front end?

dineshsingh — Mon, 22 Dec 2014 12:42:48 GMT

Dear Gysbert,

Thanks for the reply. Can you please suggest an solution for the same.