Using Variable in Set Expression

[Aravindvunnam]

Hi 

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

• set expression,
• qliksense development
•  

[rwunderlich · Accepted solution]

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)'}

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com