topic Re: Cummulative sum on Total in QlikView

Cummulative sum on Total

suvechha_b — Fri, 10 Jul 2015 09:20:46 GMT

Hi,

Can anyone help me to write the following expression :

Budget Value is calculated with the following variable :

vPerFormulaBud : sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

I need 1047369499/26

So,

Trading Day 1 : 40283442.26

Trading Day 2 : 80566884.52

Trading Day 26 : 1047369499

Gysbert_Wassenaar — Fri, 10 Jul 2015 09:24:42 GMT

Create another variable

vPerFormulaBudTotal : =sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

Use that variable in your chart expression: = $(vPerFormulaBudTotal) / (27-[Trading Day])

suvechha_b — Fri, 10 Jul 2015 09:25:03 GMT

Sales Vaue is working correct by using straight table and full accumulation.

But my requirement is in Budget Value :

Output :

Trading Day 1 : 40283442.26

Trading Day 2 : 80566884.52

Trading Day 26 : 1047369499

suvechha_b — Fri, 10 Jul 2015 09:31:57 GMT

No its not working .

suvechha_b — Fri, 10 Jul 2015 09:34:27 GMT

No its not working .

It looks like the following image :

But my requirement is in Budget Value :

Output :

Trading Day 1 : 40283442.26

Trading Day 2 : 80566884.52

Trading Day 26 : 1047369499

Gysbert_Wassenaar — Fri, 10 Jul 2015 09:35:45 GMT

Post a qlikview document that demonstrates the issue.

suvechha_b — Fri, 10 Jul 2015 10:59:08 GMT

I tried to pull data for particular product as my model is to long to upload.

PFA.