Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.