If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi, i'm trying to count all dates that are above a date stored in a variable, in my data load statement i have
Let vStartDate=date('01/04/2020');Let vEndDate=date('01/07/2020');
In my sheet formula, i would then like to count all dates where the date in the field FinalReportDate is >= vStartDate
I've tried various examples on the forum but cant seem to get any to work, whats the correct syntax ?
Try like below
Let vStartDate=date(MakeDate(2020,04,01));Let vEndDate=date(MakeDate(2020,07,01));