Expression on Pivot table

Sat, 13 Nov 2010 00:03:34 GMT

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.

Expression on Pivot table

Sat, 20 Nov 2010 19:22:40 GMT

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.

topic Expression on Pivot table in QlikView

Expression on Pivot table

Expression on Pivot table