Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to figure out this set analysis and I cannot get it to work. Basically I am trying to count a set of distinct values if they fall in the past 7 days and if their status is delivered:
count(distinct {<CalendarDate = {'>=$(=$(vSevenDaysAgo))'}, Status = {'DELIVERED'}>} OrderNumber)
This works by itself:
count(distinct {<Status = {'DELIVERED'}>} OrderNumber)
But when I add in the date it comes up with Zero.
This worked in the Desktop Version I just downloaded. Thank you. I'll have to figure out something for our current version of Qlik Sense.