Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression on Pivot table

I am working on the pivot table and I came across this post

http://community.qlik.com/forums/t/17011.aspx

The solution in the post by (John W) works fine for my pivot table. However, I have only one problem. As my pivot table comprises of two cycle group dimension it crashes after doing an extensive calculation on the lowest level. Is there any way we can performance tune below expression or write it in some other way?

Sum (AMOUNT) / pick(dimensionality()
,sum(TOTAL AMOUNT)
,aggr(nodistinct sum(AMOUNT), [Cycle_Group_1])
,aggr(nodistinct sum(AMOUNT), [Cycle_Group_1],[Cycle_Group_2])
,aggr(nodistinct sum(AMOUNT), [Cycle_Group_1],[Cycle_Group_2],Field_Name_1))

Where Cycle_Group_1 goes '5' level down and Cycle_Group_2 goes '6' level down.

1 Reply
Not applicable
Author

Apologies. After further analysis of the above mentioned problem, I found out that Crashing of chart had to do with the datamodel. And when I fixed that part my chart works fine at every level. Thanks John W.