Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following variable:
LET vMonthStart = monthstart(Today());
Then in my data load I have:
WHERE "My_Date" < $(vMonthStart);
It returns no records but if I use WHERE "My_Date" <> $(vMonthStart); it does.
I need the less than function to work rather than not equal to.
What am I doing wrong??
Many thanks
May be add single quotes around your variable
WHERE "My_Date" < '$(vMonthStart)';
Cheers Sunny, that seems to work. Thanks for the prompt response.
May be you can use it direct also
Ex:-
WHERE "My_Date" < vMonthStart
Or
WHERE "My_Date" < '$(vMonthStart)'
That's awesome, please close the thread if you got what you wanted.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny