Discussion Board for collaboration related to QlikView App Development.
I have a Date field and would like to get the Max(Date) of the previous month.
Tried this expression but it doesn't work quiet nicely.
How can I get this?
That is because that expression is taking the max from (one month subtracted for each date) which is the current max e.g. May 26 and then one month subtracted so April26. If you want the max of the previous month use as suggested