If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am trying to only include results where the date is equal to or greater than today and minus last 24 hours. The clause I have added does not seem to be working, can someone please help?
The format of 'Date' is: DD/MM/YYYY hh:mm:ss
OrderID as OID1,
FROM [lib://OnTrack QVD's (corpbh_qlikadmin)/OrderLegsPlus.qvd]
where DATE(Timestamp(PODDate)) >= Today() - 1;
Thank you in advance.
the script seems fine. Do you get any error message or just get empty dataset?
Is there column with name PODDate? - when you get error.
Are you sure this method suits you requirements? I mean the day substraction is not equal to 24hour minus,
if the minus 24 hours is important then try compare twotimestamps:
Where Timestamp(PODDate) >= timestamp(now()-1);
Hi, try this,
Where Timestamp(PODDate) >= Timestamp(ReloadTime() -1);