topic Re: Change expression according with dimension value on pivot table in QlikView https://community.qlik.com/t5/QlikView/Change-expression-according-with-dimension-value-on-pivot-table/m-p/1028435#M936101 <HTML><HEAD></HEAD><BODY><P>Maybe you can use something like</P><P></P><P>=If( DimensionField = 'HEADCOUNT',</P><P>&nbsp;&nbsp;&nbsp; Avg ( Value),</P><P>&nbsp;&nbsp; Sum(Value)</P><P>)</P></BODY></HTML> Sat, 13 Feb 2016 23:02:22 GMT swuehl 2016-02-13T23:02:22Z Change expression according with dimension value on pivot table https://community.qlik.com/t5/QlikView/Change-expression-according-with-dimension-value-on-pivot-table/m-p/1028434#M936100 <HTML><HEAD></HEAD><BODY><P>Hello everyone:</P><P>I have a pivot table, and I need to change the formula expression according with Dimension Value. I mean when Dimension value on Pivot table is "HEADCOUNT" I need to Calculate the average, instead of SUM like others dimensions.</P><P><IMG alt="13 Feb 2016.png" class="jive-image image-1" src="/legacyfs/online/114571_13 Feb 2016.png" style="height: 238px; width: 620px;" /></P><P>Any idea will be appreciate.</P><P>Thank you</P></BODY></HTML> Sat, 13 Feb 2016 20:17:28 GMT https://community.qlik.com/t5/QlikView/Change-expression-according-with-dimension-value-on-pivot-table/m-p/1028434#M936100 2016-02-13T20:17:28Z Re: Change expression according with dimension value on pivot table https://community.qlik.com/t5/QlikView/Change-expression-according-with-dimension-value-on-pivot-table/m-p/1028435#M936101 <HTML><HEAD></HEAD><BODY><P>Maybe you can use something like</P><P></P><P>=If( DimensionField = 'HEADCOUNT',</P><P>&nbsp;&nbsp;&nbsp; Avg ( Value),</P><P>&nbsp;&nbsp; Sum(Value)</P><P>)</P></BODY></HTML> Sat, 13 Feb 2016 23:02:22 GMT https://community.qlik.com/t5/QlikView/Change-expression-according-with-dimension-value-on-pivot-table/m-p/1028435#M936101 swuehl 2016-02-13T23:02:22Z Re: Change expression according with dimension value on pivot table https://community.qlik.com/t5/QlikView/Change-expression-according-with-dimension-value-on-pivot-table/m-p/1028436#M936102 <HTML><HEAD></HEAD><BODY><P>Thank you.</P><P>My best regards</P></BODY></HTML> Sun, 14 Feb 2016 00:23:01 GMT https://community.qlik.com/t5/QlikView/Change-expression-according-with-dimension-value-on-pivot-table/m-p/1028436#M936102 2016-02-14T00:23:01Z