topic Cumulative average in gauge chart in QlikView https://community.qlik.com/t5/QlikView/Cumulative-average-in-gauge-chart/m-p/1058904#M354712 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have month wise values and I want to represent the average of cumulative of those values in a gauge chart.</P><P></P><P>The formula I have used is:</P><P><STRONG>NUM(AVG(AGGR(rangesum(count(distinct V1),above(count(distinct <SPAN style="font-size: 13.3333px;">V1</SPAN>),1,RowNo()))</STRONG></P><P><STRONG>/</STRONG></P><P><STRONG>rangesum(count(distinct V2),above(count(distinct V2),1,RowNo())),Month))*100,'###.##')</STRONG></P><P></P><P>But since it is a gauge chart, I don't think above() function will work here. </P><P>Can someone please suggest me what formula should I use.</P><P></P><P>Thanks in advance</P><P>Parul</P></BODY></HTML> Mon, 11 Jan 2016 05:31:57 GMT 2016-01-11T05:31:57Z Cumulative average in gauge chart https://community.qlik.com/t5/QlikView/Cumulative-average-in-gauge-chart/m-p/1058904#M354712 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have month wise values and I want to represent the average of cumulative of those values in a gauge chart.</P><P></P><P>The formula I have used is:</P><P><STRONG>NUM(AVG(AGGR(rangesum(count(distinct V1),above(count(distinct <SPAN style="font-size: 13.3333px;">V1</SPAN>),1,RowNo()))</STRONG></P><P><STRONG>/</STRONG></P><P><STRONG>rangesum(count(distinct V2),above(count(distinct V2),1,RowNo())),Month))*100,'###.##')</STRONG></P><P></P><P>But since it is a gauge chart, I don't think above() function will work here. </P><P>Can someone please suggest me what formula should I use.</P><P></P><P>Thanks in advance</P><P>Parul</P></BODY></HTML> Mon, 11 Jan 2016 05:31:57 GMT https://community.qlik.com/t5/QlikView/Cumulative-average-in-gauge-chart/m-p/1058904#M354712 2016-01-11T05:31:57Z Re: Cumulative average in gauge chart https://community.qlik.com/t5/QlikView/Cumulative-average-in-gauge-chart/m-p/1058905#M354713 <HTML><HEAD></HEAD><BODY><P>Well since you are using Aggr function, this might still work. But just by looking at the expression it would be difficult to give any suggestions. Would you be able to share a sample with us Parul?</P></BODY></HTML> Mon, 11 Jan 2016 12:46:21 GMT https://community.qlik.com/t5/QlikView/Cumulative-average-in-gauge-chart/m-p/1058905#M354713 sunny_talwar 2016-01-11T12:46:21Z