topic Re: Pivot Table Transpose with Cumulative in Qlik in QlikView

Pivot Table Transpose with Cumulative in Qlik

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

How to do Cumulative sum in pivot table with transpose level in qlik sense?

I can calculative cumulative sum in pivot table but,

Here my requirement is when i do transpose my cumulative expression is showing data is "zero".

for your reference i attached snapshot.

INPUT:

T1:

Load * Inline [

ID,PRODUCT,SALES,MONTH

1,A,100,JAN2018

2,B,200,FEB2018

3,C,300,MAR2018

4,D,400,OCT2017

5,E,500,NOV2017

6,F,600,DEC2017

];

Expected O/P:-

Measures Month

Jan2018 Feb2018 Mar2018 Oct2017 Nov2017 Dec2017

Sales 100 200 300 400 500 600

Cumulative sales 100 300 600 1000 1500 2100

Regards

Mahesh

Re: Pivot Table Transpose with Cumulative in Qlik

qlikview979 — Thu, 24 May 2018 09:27:00 GMT

loveisfail

Re: Pivot Table Transpose with Cumulative in Qlik

qlikview979 — Thu, 24 May 2018 09:32:38 GMT

My Dimension and Expression is

Dimension:-Month

Expression:-Sum(Sales)

Cumulative Expression:- Rangesum(Above(Sum(Sales),0,rowno()))

Can any one help me on this?

Regards

mahesh

Re: Pivot Table Transpose with Cumulative in Qlik

qlikview979 — Thu, 24 May 2018 09:54:40 GMT

Hi all,

Is it Possible in qlik?

mbaeyens

stalwar1

Regards

Mahesh

Re: Pivot Table Transpose with Cumulative in Qlik

Miguel_Angel_Baeyens — Thu, 24 May 2018 09:56:40 GMT

Yes, it's possible. But if you pivot you should change the expression to use Before() -for rows- instead of Above() -for columns-

Re: Pivot Table Transpose with Cumulative in Qlik

qlikview979 — Thu, 24 May 2018 10:04:11 GMT

Hi Migual,

I done same what u suggested ,now also i am getting result "Zero".

Can you check with my data?

Regards

Mahesh

Re: Pivot Table Transpose with Cumulative in Qlik

jyothish8807 — Thu, 24 May 2018 10:04:49 GMT

Try like this:

aggr(Rangesum(Above(Sum(Sales),0,rowno())),Month)

Br,

Re: Pivot Table Transpose with Cumulative in Qlik

jyothish8807 — Thu, 24 May 2018 10:05:57 GMT

Re: Pivot Table Transpose with Cumulative in Qlik

qlikview979 — Thu, 24 May 2018 10:09:07 GMT

HI KC,

In app result is showing '-' ,can you please the sample app?

Regards

Mahesh

Re: Pivot Table Transpose with Cumulative in Qlik

jyothish8807 — Thu, 24 May 2018 10:21:03 GMT

Please refer the attached.

Re: Pivot Table Transpose with Cumulative in Qlik

jyothish8807 — Thu, 24 May 2018 10:22:04 GMT

As per your inline table all field names are in ALL CAPS.

aggr(Rangesum(Above(Sum(SALES),0,rowno())),MONTH)

Re: Pivot Table Transpose with Cumulative in Qlik

Anil_Babu_Samineni — Thu, 24 May 2018 10:28:02 GMT

Here we go ??

Update - QVW also attached? Because, Your forum is with Qlikview but your image is with Qliksense