Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am struggling to add days to a date in a Qlik sense expression
This works:
COUNT({$<Purchase_Date={"<=$(varMaxDate)"}>}DISTINCT(POLICY_ID_MED))
But if i try to add days to the date field it doesn't return anything, I've tried both of these but neither return anything.
COUNT({$<Purchase_Date+30={"<=$(varMaxDate)"}>}DISTINCT(POLICY_ID))
COUNT({$<DATE(Purchase_Date+30,'DD/MM/YYYY')={"<=$(varMaxDate)"}>}DISTINCT(POLICY_ID))
Variable varMaxDate is populated from a variable input box and is in DD/MM/YYYY format and there are definitely valid records that should be returned. But its not even returning a zero count.
What i am doing wrong?
Thanks