Discussion Board for collaboration related to Creating Analytics for QlikView.
I am trying to pull out only the last 7 days in a calculated dimension and it says the expression is OK but it does not give me any data.
Below is my calculated dimension:
=if(Date >= today()-7 and Date = today(), Date)
Date is my field name for date.
Thanks for your help.
=if(Date >= today()-7 and Date <= today(), Date, null())
then check the box "Suppress Null Values"
let me know
=if(Date>= today()-7 and Date<= today(), Date)
Use this in Dimension and after doing this check the Suppress when Value is Null Option.
Thank you for your quick reply.
It works but the i get numerical values such as 42166,177271412
As the expression is in the Dimension tab, I can't change it in the 'Number' tab. :-(
It works fine now.
Use the Date Format in the Front end if you are getting Numerical date Values.
=Date(if(Date >= today()-7 and Date <= today(), Date, null()),'DD/MM/YYYY')
If you want to check on today then create one variable,using peek i.e,vMax , then put dimension as
=if(Date >= today()-7 and today()='$(vMax)',Date,null())
And suppress null values.
Could you upload a sample qvw file if possible so that we can look into.
=if(Date >= today()-7 and Date <= today(), Date(Date,'DD-MM-YYYY'), null())
If the question is closed please mark the answers to close the discussion