Discussion Board for collaboration related to QlikView App Development.
How can I customize my Dimension statement to display only value in the previous month?
IF(max(date(Mydate)) >=monthstart(today(),-1) AND max(date(Mydate)) <= monthend(today(),-1),SomeNames)
but its not working I'd really appreciate any help with this.
QV has a month function that can be used:
If(Month(Mydate) = Month(Today())-1,SomeNames)
The "-1" in the later part is to get the previous month.