Get previous Month Value in Graphic

[maxime66]

HI,

I would like to get the value of previous Month in front of each current month.

Here is a qlikview exemple.

My expression ("Month-1") works fine when i filter a date but not for every value.

I don't want to use the "Above" function because the graphic must be sorted by other dimensions.

Thanx for your help

++

max.

[ankit777]

Hi,

You can use addmonths function

[maxime66]

i forgot the file , sorry

[pratap6699]

dim-->months

expre-->sum({<months={"=$(=month-1)"}>}sales)

listbox-->month

when you select feb it displays jan sales

[maxime66]

Hi,

Actually i need the value on each Month line,

without selecting any Month...

[#6]

Hi man,

the answer :

left join(stock)
LOAD
epargne_stocks.date_situation,
contrat,
if([contrat] = Previous([contrat]), [epargne_stocks.valeur_contrat] - Previous([epargne_stocks.valeur_contrat])) as Variation_PM
Resident
stock
Order by contrat,epargne_stocks.date_situation;