topic Re: rolling last year total in QlikView

rolling last year total

selcukcadir — Mon, 11 Nov 2013 18:47:23 GMT

Hi,

gwassenaar published (thanks you gwassenaar)

I want to add

last year total sales

add as a new column

This can be done added ?

selcukcadir — Tue, 12 Nov 2013 05:54:23 GMT

Hi all,

Could you give support to this issue?

thanks.

selcukcadir — Tue, 12 Nov 2013 12:33:25 GMT

Hi all ,

set analysis ,How to solve this problem?

selcukcadir — Tue, 12 Nov 2013 15:35:01 GMT

hi all,

correct ;

if(Year(AsOfPeriod)-1 = '2009',sum(total {$<Year={$(=2009)},PeriodType={'Current'}>} Sales))

But not correct ; dynamic solution

1 trial ; sum(total {$<Year={"=$(#=Year(=Only(AsOfPeriod)-1))"},PeriodType={'Current'}>} Sales)

2 trial ; sum(total {$<Year = {"$(Year(AsOfPeriod)-1)"},PeriodType={'Current'}>} Sales)

vLast = Year(AsOfPeriod)-1

3 Trial ; sum(total {$<Year={$(vLast)},PeriodType={'Current'}>} Sales)

Why not correct ? Help....

Gysbert_Wassenaar — Wed, 13 Nov 2013 17:22:40 GMT

Add records to the AsOf table to link each period with every month of the previous year:

CONCATENATE (AsOfPeriodTable)

load Period as AsOfPeriod

,'LastYearTotal' as PeriodType

,date(addmonths(yearstart(Period),-iterno()),'YYYYMM') as Period1

,Year(Period) as Year

Resident PeriodTbl

while IterNo()<=12;

Then use this expression: sum({<PeriodType={'LastYearTotal'}>}Sales)

selcukcadir — Wed, 13 Nov 2013 18:11:07 GMT

Thank you Gysbert,

I have another question. Can you help me.

Period Year Ago and YTD Year Ago how to add ?

thank you for great post