topic Get previous Month Value in Graphic in QlikView

Get previous Month Value in Graphic

maxime66 — Wed, 03 Jun 2015 11:29:23 GMT

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.

Re: Get previous Month Value in Graphic

ankit777 — Wed, 03 Jun 2015 11:31:05 GMT

Hi,

You can use addmonths function

Re: Get previous Month Value in Graphic

maxime66 — Wed, 03 Jun 2015 11:32:25 GMT

i forgot the file , sorry

Re: Get previous Month Value in Graphic

pratap6699 — Wed, 03 Jun 2015 12:40:43 GMT

dim-->months

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

listbox-->month

when you select feb it displays jan sales

Re: Get previous Month Value in Graphic

maxime66 — Wed, 03 Jun 2015 14:35:04 GMT

Hi,

Actually i need the value on each Month line,

without selecting any Month...

Re: Get previous Month Value in Graphic

Thu, 04 Jun 2015 14:26:53 GMT

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;