topic Re: Expression in Variable in QlikView

Expression in Variable

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

Hi All,

I hve below expression

sum({<
[Date]={"$(=date(max( { 1 < Month_Name={"$(=MonthName(AddMonths([Date],-1)))" } >} [Date] ), 'YYYY-MM-DD'))"}
>}Amount)

Now I want to copy this expression in variable and need to use variable in chart expression but as this expression already contains " (Quote), I am not able to store it in variable.

Can anyone help me to do the same.

Re: Expression in Variable

sunny_talwar — Wed, 07 Oct 2020 12:43:09 GMT

@soha1902 Why are you not able to store this in a variable if there are quotes? I don't think variables have issues with quotes

Re: Expression in Variable

soha1902 — Wed, 07 Oct 2020 12:48:28 GMT

Hello @sunny_talwar , Actually in variable we need to add "" before and end of the expression like

vAmount = "sum({<
[Date]={"$(=date(max( { 1 < Month_Name={"$(=MonthName(AddMonths([Date],-1)))" } >} [Date] ), 'YYYY-MM-DD'))"}
>}Amount)"

but above expression throws error in front end when I am defining the vAmount variable.

Re: Expression in Variable

sunny_talwar — Wed, 07 Oct 2020 13:18:41 GMT

@soha1902 Are you doing this in the script?

Re: Expression in Variable

soha1902 — Wed, 07 Oct 2020 13:21:57 GMT

No in .txt file and using variables in qlik expression.