topic Re: Sum in Qlik Sense pivot table in App Development

Sum in Qlik Sense pivot table

ramkrishna86 — Tue, 25 Apr 2017 11:33:09 GMT

Hi,

I need your help regarding below functionality. I have data in pivot table as below-

What i want is Begining of next month should be ending of previous month as below-

How can i do this, i have attached QVF file.

Thanks for your help!

Re: Sum in Qlik Sense pivot table

sunny_talwar — Tue, 25 Apr 2017 11:48:55 GMT

May be try this

Beginning

RangeSum(RangeSum(Before(Sum(B)+Sum(C)-Sum(D), 1, ColumnNo())), First(Sum(A)))

Ending

Column(1) + Column(2) + Column(3) - Column(4)

Re: Sum in Qlik Sense pivot table

ramkrishna86 — Tue, 25 Apr 2017 11:56:07 GMT

Hi Sunny,

This only works for first two date in pivot table, I want this functionality for complete pivot table.

Note: Range Sum function not works in pivot table as works in other chart.

Thanks!

Re: Sum in Qlik Sense pivot table

sunny_talwar — Tue, 25 Apr 2017 12:01:36 GMT

Really? Looks like the numbers are matching for me

App Screenshot

vs. your screenshot

Where is the difference?

Re: Sum in Qlik Sense pivot table

ramkrishna86 — Tue, 25 Apr 2017 14:49:53 GMT

Hi Sunny,

I tried the same but can't get result, could you please suggest where i am making mistake.

I have attached QVF file.

Thanks!

Re: Sum in Qlik Sense pivot table

sunny_talwar — Tue, 25 Apr 2017 15:02:31 GMT

I think you don't want to use Sum(A) in the before function

RangeSum(RangeSum(Before(Sum(A)-Sum(B)-Sum(C)+Sum(D)+Sum(E)+Sum(F)-Sum(G)+Sum(H), 1,

ColumnNo())), First(Sum(A)))

Try this:

RangeSum(RangeSum(Before(-Sum(B)-Sum(C)+Sum(D)+Sum(E)+Sum(F)-Sum(G)+Sum(H), 1,

ColumnNo())), First(Sum(A)))

Re: Sum in Qlik Sense pivot table

ramkrishna86 — Tue, 25 Apr 2017 15:34:20 GMT

Thank you So much Sunny

Re: Sum in Qlik Sense pivot table

P_Kumar — Sat, 12 Jan 2019 07:49:50 GMT

Hi Sunny,

I have observed following in your test app. The calculations where ever Rangesum is being used, isn't showing correctly upon filter selection where as it's showing correct without a filter. Kindly check the screenshots and advise on the issue since I am facing same issue with one of my apps. Thanks