topic Linear Gauge in bar chart settings - Question in QlikView https://community.qlik.com/t5/QlikView/Linear-Gauge-in-bar-chart-settings-Question/m-p/1051038#M936602 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I am fighting with 2 issues regarding linear gauge setting:</P><P></P><P>1. I would like to get the below table (attached), however as a dimension, instead of a fixed one (now Kontrakt) I would like to use a cyclic group. The problem I have is to set a max value for gauge (for fixed one, I use <SPAN style="color: #ff6600;">max(aggr(sum(czas_pracy),Kontrakt))</SPAN> - works perfect. Question - what formula should I use to have the max setting of the linear gauge correct for a cyclic group?</P><P></P><P>2. in the linear Gauge, I would like one specific value of one specific dimension (so, now the specific dimension is Kontrakt, and the specific value for this dimension is lets say "waisted_time") to have a red color on the gauge, not green. Is it possible? how?</P><P></P><P>Thanks a lot in advance for your help</P><P>Robert</P></BODY></HTML> Wed, 17 Feb 2016 11:04:19 GMT 2016-02-17T11:04:19Z Linear Gauge in bar chart settings - Question https://community.qlik.com/t5/QlikView/Linear-Gauge-in-bar-chart-settings-Question/m-p/1051038#M936602 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I am fighting with 2 issues regarding linear gauge setting:</P><P></P><P>1. I would like to get the below table (attached), however as a dimension, instead of a fixed one (now Kontrakt) I would like to use a cyclic group. The problem I have is to set a max value for gauge (for fixed one, I use <SPAN style="color: #ff6600;">max(aggr(sum(czas_pracy),Kontrakt))</SPAN> - works perfect. Question - what formula should I use to have the max setting of the linear gauge correct for a cyclic group?</P><P></P><P>2. in the linear Gauge, I would like one specific value of one specific dimension (so, now the specific dimension is Kontrakt, and the specific value for this dimension is lets say "waisted_time") to have a red color on the gauge, not green. Is it possible? how?</P><P></P><P>Thanks a lot in advance for your help</P><P>Robert</P></BODY></HTML> Wed, 17 Feb 2016 11:04:19 GMT https://community.qlik.com/t5/QlikView/Linear-Gauge-in-bar-chart-settings-Question/m-p/1051038#M936602 2016-02-17T11:04:19Z