topic Re: Total Accumulated in QlikView

Total Accumulated

pgalvezt — Mon, 23 May 2016 13:41:24 GMT

Hello,

I've trying to accumulate my final result, but I can't get it. Only when take off my month-Week filter. I can get the result. But I need the filter by Month and Week. The real final result is 1792. to Ene and Feb and so on.

Thanks!

Re: Total Accumulated

swuehl — Mon, 23 May 2016 13:47:09 GMT

Not quite sure what you are looking for.

Maybe enabling the partial sum on Mes dimension in your pivot table chart?

Re: Total Accumulated

pgalvezt — Mon, 23 May 2016 14:05:38 GMT

Hi swuehl,

The final resul is correct. But what I want is get the acummulated For example:

Ene = 1828 and Feb = 1770 right?. So both results are get them from a formula (That you divide Valor 2 / Quantity 1).So

If I clic on Ene the result is 1828 but when join Ene and Feb I need to show 1792 and no 1770. Because is an acummulated result. I forgot to say that i need to show it in a chart line. I use pivot table just to see the numbers.

Re: Total Accumulated

pgalvezt — Mon, 23 May 2016 14:41:39 GMT

Other way is show the total in the line chart is possible in QlikView?

Re: Total Accumulated

ramoncova06 — Mon, 23 May 2016 15:51:58 GMT

are you doing a side by side comparison between Real and Plan ?

my assumption is that you want this divide by whatever number of months/weeks you are displaying in the line chart, right ?

Re: Total Accumulated

pgalvezt — Mon, 23 May 2016 16:51:12 GMT

Hi Ramón:

are you doing a side by side comparison between Real and Plan ? R: YES...

my assumption is that you want this divide by whatever number of months/weeks you are displaying in the line chart, right ? RIGTH...

I need To Show For ene feb obviously there are more months: (I dont want to show 1770 That is feb value and no the cumulative)

Would be:

Real Plan

1828 1837

1792 1795

That cumulative show them in chart line

Like: Real (In Line Chart)

ene Feb

1828 1792

. .

Same Thing with Budget and can compare two expressions.