topic Gauge Chart in QlikView https://community.qlik.com/t5/QlikView/Gauge-Chart/m-p/569587#M1119704 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am trying to create a gauge chart for one division. I want it to be locked so that when you select other divisions it doesn't change. If possible also locked on max year.</P><P></P><P>Expression:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN>rangesum<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">total</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({1&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">DivisionName</SPAN><SPAN style="font-size: 8pt;"> = 'XXX'&gt;}RevenueAmount), 0, rowno(Total)))/rangesum(above(total sum({1&lt;DivisionName = 'XXX'&gt;}BudgetAmount), 0, rowno(Total))) </SPAN></P></BODY></HTML> Tue, 11 Feb 2014 11:51:21 GMT 2014-02-11T11:51:21Z Gauge Chart https://community.qlik.com/t5/QlikView/Gauge-Chart/m-p/569587#M1119704 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am trying to create a gauge chart for one division. I want it to be locked so that when you select other divisions it doesn't change. If possible also locked on max year.</P><P></P><P>Expression:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN>rangesum<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">total</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({1&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">DivisionName</SPAN><SPAN style="font-size: 8pt;"> = 'XXX'&gt;}RevenueAmount), 0, rowno(Total)))/rangesum(above(total sum({1&lt;DivisionName = 'XXX'&gt;}BudgetAmount), 0, rowno(Total))) </SPAN></P></BODY></HTML> Tue, 11 Feb 2014 11:51:21 GMT https://community.qlik.com/t5/QlikView/Gauge-Chart/m-p/569587#M1119704 2014-02-11T11:51:21Z Re: Gauge Chart https://community.qlik.com/t5/QlikView/Gauge-Chart/m-p/569588#M1119705 <HTML><HEAD></HEAD><BODY><P>you can use alternate states</P></BODY></HTML> Tue, 11 Feb 2014 12:16:02 GMT https://community.qlik.com/t5/QlikView/Gauge-Chart/m-p/569588#M1119705 2014-02-11T12:16:02Z Re: Gauge Chart https://community.qlik.com/t5/QlikView/Gauge-Chart/m-p/569589#M1119706 <HTML><HEAD></HEAD><BODY><P>Yes I now got the gauge charts just the way i want them. Thanks!</P><P></P><P>Do you maybe got a clue how i can let them show the last week thats in the system.</P><P>Now i have to select the week from 2014 they'll show but is it possible they automatically select the last week?</P></BODY></HTML> Tue, 11 Feb 2014 15:20:17 GMT https://community.qlik.com/t5/QlikView/Gauge-Chart/m-p/569589#M1119706 2014-02-11T15:20:17Z