Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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.