Date variable doesn't work

[melistrkglu]

Hello Qlik Users,

My question is related to an expression includes a variable doesn't work. 

I have a variable is vDate:   =AddMonths(max([Ship Date]),-2)

I have an expression: =sum({<[Order Date]={'>$(vDate)'}>} Sales)  

The result of expression just looks zero. I attached example qvf, excel files and screenshot in order to able to analyze it.

Thanks for your help.

King Regards,

Melis

[tresesco · Accepted solution]

Replace single quotes with double quotes, like:

sum({<[Order Date]={">$(vDate)"}>} Sales)