Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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.