Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashish_2511
Creator
Creator

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

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) -

Capture.PNG

Transposed Table (Not Working) -

Capture1.PNG

Attached is the reduced QVW.

Regards

-Sneh

1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi Sneh,

PFA. You have to use "Before" function.

Thanks,

Nisha

View solution in original post

4 Replies
Anonymous
Not applicable

Hi Sneh,

PFA. You have to use "Before" function.

Thanks,

Nisha

Anil_Babu_Samineni

It should help

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

Tell me, Expected O/P

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ashish_2511
Creator
Creator
Author

Thank you Nisha. that worked.

ashish_2511
Creator
Creator
Author

Thanks Anil. This helped.