Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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
nishaloganathan
Creator II
Creator II

Hi Sneh,

PFA. You have to use "Before" function.

Thanks,

Nisha

View solution in original post

4 Replies
nishaloganathan
Creator II
Creator II

Hi Sneh,

PFA. You have to use "Before" function.

Thanks,

Nisha

View solution in original post

Anil_Babu_Samineni

It should help

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

Tell me, Expected O/P

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.