Year-1 / Month -1

[master_student]

Hello Guys,

I hope all is good.

I need to get the value of month -1 (of the selected month), YEAR-1 of the expression bellow :

=num(sum( [Active Base] )  ,'# ##0')

My fields are month of date, year of date

Thanks a lot

[zhadrakas]

Hello,

try like this

num(Sum({$<Year={"=max(Year)-1"}, Month={"=max(Month)-1"}>}[Active Base]) , '# ##0')

regards

tim

[prma7799]

Try like this

=Num(Sum({$<[Posting Date]={"=max(Year([Posting Date]))-1"}, [Posting Date]={"=max(Month([Posting Date]))-1"}>}[Gross Sales Amount]) , '###0')

[techvarun]

Num((sum({<[month of date]={$(=Month(TODAY())-1)}>} [Active Base]) + sum({<[Year of date]={$(=Month(TODAY())-1)}>} [Active Base])),'# ##0')

[its_anandrjs]

Try this way in Month use the Datefield

=num(sum( {<Year={"$(=Max(Year)-1)"}, Month={"$(=Max(Month(DateField))-1)"} >} [Active Base] )  ,'# ##0')

[its_anandrjs]

One question how many date fields you have.

[Anil_Babu_Samineni]

This one works, but you need top assign dollar symbol

[Anil_Babu_Samineni]

You can't write like this, because Set analysis explorer miffed with only one field for one time.

[prma7799]

Hi Anil,

I appreciate your suggestion but could you please explain more. I didn't understand ...

Thanks 

[Anil_Babu_Samineni]

The thing is simple, you added [posting Date] as 2 times In the left hand side of degrade expression. That means qlikview doesn't capture for which option need to calculate so the only option is either used year and month calculation from field called date field. Does it likable?