Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

set analysis

I need to show the income of last month.

I have:

=num(sum({<Month_Num={$(vMonthCal)},Year={2017}>} [TRUEPRICE]),'#,##0 ')

once vMonthCal==num(Month(today()))-1


and yet when i pick another quarter, the numbers change and not remain the numbers of the previous month.


How do I fix it..?

1 Reply
vishsaggi
Champion III
Champion III

May be this? Quarter is like your Quarter field name. If your name is different replace with your actual Quarterfieldname.

=num(sum({<Month_Num={$(vMonthCal)},Year={2017}, Quarter=>} [TRUEPRICE]),'#,##0 ')