Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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.