Total Accumulated

[pgalvezt]

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!

[swuehl]

Not quite sure what you are looking for.

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

[pgalvezt]

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.

[pgalvezt]

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

[ramoncova06]

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 ?

[pgalvezt]

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.