topic Percentages in expanded pivot table in QlikView https://community.qlik.com/t5/QlikView/Percentages-in-expanded-pivot-table/m-p/145505#M590311 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with a calculated dimension, and am trying to get percentages to the calculated dimension level.</P><P>Collapsed, the percentages are fine. Expanded, '-' populated cells show up. I've worked over aggr with this with no luck. Sample aggr:</P><P>(sum(total_claim_count) / (aggr(sum(claim_count), claim_name, claim_status))</P><P>The calculated dimension involves three 'if' statements and does not plug into the aggr.</P><P>This has used up my blood on the keyboard supply for the weekend.</P><P>Help vastly appreciated.</P><P>kencho</P></BODY></HTML> Mon, 01 Jun 2009 04:43:04 GMT 2009-06-01T04:43:04Z Percentages in expanded pivot table https://community.qlik.com/t5/QlikView/Percentages-in-expanded-pivot-table/m-p/145505#M590311 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with a calculated dimension, and am trying to get percentages to the calculated dimension level.</P><P>Collapsed, the percentages are fine. Expanded, '-' populated cells show up. I've worked over aggr with this with no luck. Sample aggr:</P><P>(sum(total_claim_count) / (aggr(sum(claim_count), claim_name, claim_status))</P><P>The calculated dimension involves three 'if' statements and does not plug into the aggr.</P><P>This has used up my blood on the keyboard supply for the weekend.</P><P>Help vastly appreciated.</P><P>kencho</P></BODY></HTML> Mon, 01 Jun 2009 04:43:04 GMT https://community.qlik.com/t5/QlikView/Percentages-in-expanded-pivot-table/m-p/145505#M590311 2009-06-01T04:43:04Z Percentages in expanded pivot table https://community.qlik.com/t5/QlikView/Percentages-in-expanded-pivot-table/m-p/145506#M590312 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I understand ur problem. Better attach ur here?</P><P>-Sathish</P></BODY></HTML> Mon, 01 Jun 2009 20:03:04 GMT https://community.qlik.com/t5/QlikView/Percentages-in-expanded-pivot-table/m-p/145506#M590312 sathishkumar_go 2009-06-01T20:03:04Z Percentages in expanded pivot table https://community.qlik.com/t5/QlikView/Percentages-in-expanded-pivot-table/m-p/145507#M590313 <HTML><HEAD></HEAD><BODY><P>The solution is:</P><P>(sum(total_claim_count) / (aggr(nodistinct sum(claim_count), claim_name, claim_status))</P><P>nodistinct is what does the trick!</P></BODY></HTML> Wed, 03 Jun 2009 22:58:35 GMT https://community.qlik.com/t5/QlikView/Percentages-in-expanded-pivot-table/m-p/145507#M590313 2009-06-03T22:58:35Z Percentages in expanded pivot table https://community.qlik.com/t5/QlikView/Percentages-in-expanded-pivot-table/m-p/145508#M590314 <HTML><HEAD></HEAD><BODY><P>Thank You. Thank You. Thank You!<IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P></BODY></HTML> Tue, 03 Nov 2009 07:19:42 GMT https://community.qlik.com/t5/QlikView/Percentages-in-expanded-pivot-table/m-p/145508#M590314 2009-11-03T07:19:42Z Percentages in expanded pivot table https://community.qlik.com/t5/QlikView/Percentages-in-expanded-pivot-table/m-p/145509#M590315 <HTML><HEAD></HEAD><BODY><P>Why, nodistinct does the trick ?</P></BODY></HTML> Sat, 28 Nov 2009 01:56:53 GMT https://community.qlik.com/t5/QlikView/Percentages-in-expanded-pivot-table/m-p/145509#M590315 pablolabbe 2009-11-28T01:56:53Z