Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart display on date range condition

Hello:

How can I customize my Dimension statement to display only value in the previous month?

I tried

=



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.

Thanks

AO

1 Reply
vupen
Partner
Partner

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.