topic Re: Sum in QlikView

Sum

deepakqlikview_123 — Wed, 30 Apr 2014 08:04:34 GMT

Hello Team,

Can you please suggest how to make sum in pivot table as for highlighted data as shown in attachment.

Thanks,

Re: Sum

Wed, 30 Apr 2014 08:12:52 GMT

go to Object Properties > Expressions and tick Full Accumulation

Re: Sum

deepakqlikview_123 — Wed, 30 Apr 2014 08:18:08 GMT

Hi Bertrand,

Thanks for reply.

Tick full accumulation option is disabled in Pivot table.

thanks

Re: Sum

jagan — Wed, 30 Apr 2014 08:33:12 GMT

Hi,

Try Above()

=RangeSum(Sum(Sales), Above(TOTAL Sum(Sales), 1))

If the above expression not working then attach some sample file.

Regards,

Jagan.

Re: Re: Sum

deepakqlikview_123 — Wed, 30 Apr 2014 08:41:56 GMT

Hi JaganMohan,

PFA.

For July 1 data is 161

For july 2 200

Then in july 2 cell =July 1 data + july 2 data =361

July 3 cell=

July 1 data + july 2 data + july 3 data

Thanks

Re: Re: Re: Sum

deepakqlikview_123 — Wed, 30 Apr 2014 08:52:10 GMT

Hi Manish,

Thanks for reply.

Here is solution.

Below is formula

=RangeSum(Alt(Before([Count YTD]), 0), sum(Count))

Here Count YTD is expression name but I am not able to undershand how it works.

Thanks

Re: Re: Re: Sum

jagan — Wed, 30 Apr 2014 08:56:09 GMT

Hi,

You can refer one Expression in another expression by giving in [], the second expression uses the first expression. Also you can Column(1) for first expression, Column(2) for second. etc.,

Regards,

Jagan.

Re: Re: Re: Re: Sum

jagan — Wed, 30 Apr 2014 09:01:27 GMT

Hi,

Please find attached file solution.

Regards,

Jagan.

Re: Sum

deepakqlikview_123 — Wed, 30 Apr 2014 09:15:36 GMT

Thanks Jagan,

I t is perfect.