Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis

Hi All,

I am getting not getting a desired result withe below expression

=Sum({<MonthName={"=$(=Date(AddMonths(MonthName,-1),'MMMYY'))"}>} SALES)

It shows an 0 sales which is not true .

I want to sum the sales for the previous month, here MonthName is the current month .

Can anyone please help ?

Thanks

Shivaj

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

Try with

=Sum({<MonthName={'$(=Date(AddMonths(MonthName,-1),'MMMYY'))'}>} SALES)

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Hi

try this

Sum({<MonthName={"=$(=Date(AddMonths(max(MonthName),-1),'MMMYY'))"}>} SALES)

Also check your  'Monthname' format

stigchel
Partner - Master
Partner - Master

Try with

=Sum({<MonthName={'$(=Date(AddMonths(MonthName,-1),'MMMYY'))'}>} SALES)

Not applicable
Author

Thanks it works