Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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.