Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

ronitfromvgold
New Contributor II

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
Esteemed Contributor III

Re: set analysis

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 ')