topic Re: last month value in QlikView

last month value

sagaraperera — Wed, 25 Nov 2020 16:16:04 GMT

dear all

i already get a last year selected month value using given below formula

sum( {$<YEAR = {"$(=Only([YEAR]-1))"},CLA_CODE= {'M3'}>} [GROSSTOT] )

now i want get a last month value , pls help me

sagara

Re: last month value

MohammedMustaq — Wed, 23 Oct 2019 07:32:18 GMT

Try this

Last Month:

=Sum({<CLA_CODE= {'M3'},MonthYear={'$(=MonthName(MonthStart(Max(Date))-1))'}>}[GROSSTOT])

make sure you have Monthyear field

Thanks

Mustaq

Re: last month value

Arthur_Fong — Wed, 23 Oct 2019 07:36:43 GMT

Try this:

sum({<Month={"$(=month(AddMonths(max(<date>),-1,0)))"},<date>=,CLA_CODE= {'M3'}>} [GROSSTOT])

Replace <date> to your date column in data model.

Be sure you have Month column defined in your data model.

If Month is not defined, refer qvw attached as reference.

Thanks and regards,

Arthur Fong

Re: last month value

Brett_Bleess — Thu, 31 Oct 2019 18:07:08 GMT

Sagara, did either of the posts get you what you needed? If so, please be sure to return to the thread and use the Accept as Solution button on the one(s) that did help you get things working. If you did something else, consider posting that and then mark it, so others will know what actually worked. If you still need further assistance, please leave an update for us.

Regards,
Brett