Add previous month to selection

[#1]

hi!!

i v got tu do a graphic and chart of sells by month

but i want to compare previous month to selected month always

i do this :

=sum({$<month={$(=AddMonths(month,-1))}>} sells)

but it doesnt work

obviously because for exemple then i selected sptember there s no month agust in selected records, there s only september records !

how can i do that ???

[#2]

Hi king-greg.

You can do that using variables... See the file

Reggards,

Bruno

[#3]

it doesnt work

i create a variable : vtest=Date(AddMonths(month, -1))

i put

=sum( {$<month= {$(vtest)}>} MCD_B )

an nothing appeared!!

[MayilVahanan]

Hi

Try like this

in variable,  Month(AddMonths(Max(Date),-1)) gives Aug,if max(Date) equal to today

[Gysbert_Wassenaar]

Addmonths works with by adding a number of months to a date.

Try =sum({$<month={$(=Only(month)-1))}>} sells)

[#6]

it doesn wotks

i dont know how to do that

get 2 selections at a time !

[#7]

King, what's your Qlikview Server Version?

[#8]

11

[#9]

Create a variable "VAR_PreviousMonth" whit this expression:

=Num(Month(AddMonths(YourDateFieldHere, -1)))

And, next, in your graph's expressions, try this

Sum({<YourMonthFieldHere={'$(VAR_PreviousMonth)'}>} YourValueFieldHere)

Good Luck!

Bruno Oliveira

[MayilVahanan]

HI

Try like this

For Current month

    =Sum({<DateFieldName={"=$(=Max(DateFieldName))"}>} Sales)

For Previous month:

     =Sum({<DateFieldName={"$(=Addmonths(Max(DateFieldName), -1))"}>}Sales)

If not satisfy your requirement, can you post a sample file

Hope this helps you.