topic RangeSum(Above(Exp)),...) Doesn't work on Transposed Pivot Table. in QlikView

RangeSum(Above(Exp)),...) Doesn't work on Transposed Pivot Table.

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

Hi community

Here's the problem i'm facing -

I have a pivot table with a column called Total customers.

Total Customers = RangeSum(above(Count({<IsInYTD={1}>}current_account_id),0,4))

My actual requirement is to show the transposed form of the table but when I do so (by just dragging the dimensions to the top and Expressions to the left), The above expression doesn't work anymore and I get all zeroes.

Can Anybody suggest a workaround.

Normal Table (Working) -

Transposed Table (Not Working) -

Attached is the reduced QVW.

Regards

-Sneh

Re: RangeSum(Above(Exp)),...) Doesn't work on Transposed Pivot Table.

Anonymous — Wed, 28 Sep 2016 09:21:04 GMT

Hi Sneh,

PFA. You have to use "Before" function.

Thanks,

Nisha

Re: RangeSum(Above(Exp)),...) Doesn't work on Transposed Pivot Table.

Anil_Babu_Samineni — Wed, 28 Sep 2016 09:29:51 GMT

It should help

https://community.qlik.com/docs/DOC-8242

Tell me, Expected O/P

Re: RangeSum(Above(Exp)),...) Doesn't work on Transposed Pivot Table.

ashish_2511 — Thu, 12 Jan 2017 09:09:21 GMT

Thank you Nisha. that worked.

Re: RangeSum(Above(Exp)),...) Doesn't work on Transposed Pivot Table.

ashish_2511 — Thu, 12 Jan 2017 09:10:28 GMT

Thanks Anil. This helped.