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

Unable to get values using Month

hi,

     i m using Below expression:

    =Sum({$<Date = {"<=$(=MonthEnd(AddMonths(Max(Date),-1)))"}>}Amount)

It is Working fine .when i select on Date field it is fine .

Date field contains 21/1/2013 format

If i use Month(Date) and i select on particular month  it is giving output as 0.

Pls suggest me.

Thanks in Advance

Regards,

Divya

1 Solution

Accepted Solutions
maxgro
MVP
MVP

=Sum({$<M=,Month={"<=$(=MonthEnd(AddMonths(Max(Month),-1)))"}>}Amount)

View solution in original post

4 Replies
giakoum
Partner
Partner

this might help

anbu1984
Master III
Master III

What is the result of expr - MonthEnd(AddMonths(Max(Date),-1)) ? Is this result in date format?


Can you add sample qvw

Not applicable
Author

Hi,

PFA,

Thanks in Advance

maxgro
MVP
MVP

=Sum({$<M=,Month={"<=$(=MonthEnd(AddMonths(Max(Month),-1)))"}>}Amount)

View solution in original post