Discussion Board for collaboration regarding Qlik DataMarket.
I have a Date field with value 31-Sep-2017.
I need to get the previous month date i.e. 30-Aug-2017 from current month date.
Go to Solution.
September 2017 would be 30th as it only has 30 days.
Are you trying to get the last(previous) months max date?
Not Working Sorin.
Like for 30-Sep-2017, I should get 31-Aug-2017.
May be this
Not Working Sunny.
How would it calculate the max value from the Date in your expression.
I tried using this expression in KPI, but still not getting the result. Just Blank.
Pooja, is it in date format?
Do you use a max month to do it?
For example, this works: monthend(addmonths(MakeDate(2017,6),-1))
I guess you need to check if your date is read as date by qlikview or not. It seems that it is not read as date
Why don’t my dates work?
QlikView Date fields
Get the Dates Right
Yes, it is in date format.
I have a field named DATE with several dates in it.