Expression in Variable

[soha1902]

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.

[sunny_talwar]

@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

[soha1902]

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.

[sunny_talwar]

@soha1902 Are you doing this in the script?

[soha1902]

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