topic Re: Pivot Table Column wise Running Total in QlikView

Pivot Table Column wise Running Total

muniyandi — Tue, 13 May 2014 15:28:26 GMT

Hi,

In My Requirement are pivot table ,columnwise running total need.

i tried before function is not get correct result

if(Week=1,Column(1),Column(1)+Before(Column(3)))

kindly refer attached excel file

Thanks,

Muni

Re: Pivot Table Column wise Running Total

muniyandi — Tue, 13 May 2014 17:23:01 GMT

Hi , anybody know the answer ,kindly help to me.

Re: Pivot Table Column wise Running Total

Tue, 13 May 2014 19:58:45 GMT

Hi,

do you really need pivot table?

How many dimensions do you have in this chart?

regards

Darek

Re: Pivot Table Column wise Running Total

muniyandi — Wed, 14 May 2014 04:11:04 GMT

Hi Darek,

I need pivot table only.based on client requirement.

now i used only one dimension (week) for this chart.

Re: Pivot Table Column wise Running Total

Wed, 14 May 2014 06:28:39 GMT

Mathew,

You may define island table with 2 fields: expressionLabel, number.

Define 1 row for each normal expression from your pivot + one additiinal

for this total accumulation A.

Then in pivot:

- use expression label as additional dimension

- use pick(number, expr1, expr2...) as expression.

I will try to find example later, If you need.

Anyway, this is much easier in straight table...

Regards

Darek

14-05-2014 06:11 użytkownik "Mathew Munish" <qcwebmaster@qlik.com>

napisał:

Qlik Community <http://community.qlik.com/> Pivot Table Column
wise Running Total
reply from Mathew Munish<http://community.qlik.com/people/muniyandi?et=watches.email.thread>in *App
Development* - View the full discussion<http://community.qlik.com/message/527822?et=watches.email.thread#527822>