Using Variable in Set Expression

Aravindvunnam — Thu, 27 Apr 2023 14:15:43 GMT

i am new to qlik sense .

i try to develop set expression to find count of particular field based on max date ,

vMaxRefData = 3/31/2023 but i am getting a strange values while using the variable in the attached screen short.

can any one Help me on this & if know please write about the cause of issue that helps better in under .

thanks in Advance,

Thanks;

Aaravind

Re: Using Variable in Set Expression

rwunderlich — Thu, 27 Apr 2023 18:23:42 GMT

You have written the $() incorrectly. The date is being evaluated as an arithmetic expression 3 / 31 / 2023 = 4.783...

You should write it so the value is in single quotes like this:

REFERENCE_DATE={'$(vMaxRefDate)'}