topic Avg Multiple conditions in chart and script in QlikView https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113272#M909249 <HTML><HEAD></HEAD><BODY><P>Hello, I'm having trouble with the syntax to avg multiple values.</P><P></P><P>I have the below values and I want to exclude VTO and UTPO values in my avg expression. I would like to see both in chart and in script...Thanks in advance.</P><P></P><P></P><P>Reasons</P><P>OT</P><P>PTO</P><P>VTO</P><P>UTPO</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">avg</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">REASON</SPAN><SPAN style="font-size: 8pt;"> = '','')) </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Avg Multiple conditions in chart and script https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113272#M909249 <HTML><HEAD></HEAD><BODY><P>Hello, I'm having trouble with the syntax to avg multiple values.</P><P></P><P>I have the below values and I want to exclude VTO and UTPO values in my avg expression. I would like to see both in chart and in script...Thanks in advance.</P><P></P><P></P><P>Reasons</P><P>OT</P><P>PTO</P><P>VTO</P><P>UTPO</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">avg</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">REASON</SPAN><SPAN style="font-size: 8pt;"> = '','')) </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113272#M909249 Anonymous 2020-11-25T16:16:04Z Re: Avg Multiple conditions in chart and script https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113273#M909250 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Avg(<SPAN style="color: #ff0000;">{&lt;REASON -= {'VTO', 'UTPO'}&gt;}</SPAN> FieldName)</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">=Avg(<SPAN style="color: #ff0000;">{&lt;REASON ={'*'}-{'VTO', 'UTPO'}&gt;}</SPAN> FieldName)</STRONG></P></BODY></HTML> Tue, 14 Jun 2016 14:50:04 GMT https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113273#M909250 sunny_talwar 2016-06-14T14:50:04Z Re: Avg Multiple conditions in chart and script https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113274#M909251 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you please share some more details and add some sample app/output you are expecting.</P></BODY></HTML> Tue, 14 Jun 2016 14:50:09 GMT https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113274#M909251 krishnacbe 2016-06-14T14:50:09Z Re: Avg Multiple conditions in chart and script https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113275#M909252 <HTML><HEAD></HEAD><BODY><P>What would the FieldName be in my case?</P></BODY></HTML> Tue, 14 Jun 2016 14:56:54 GMT https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113275#M909252 Anonymous 2016-06-14T14:56:54Z Re: Avg Multiple conditions in chart and script https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113276#M909253 <HTML><HEAD></HEAD><BODY><P>Whatever you are trying to Avg <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 14 Jun 2016 15:00:09 GMT https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113276#M909253 sunny_talwar 2016-06-14T15:00:09Z Re: Avg Multiple conditions in chart and script https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113277#M909254 <HTML><HEAD></HEAD><BODY><P>I have a column "Reasons" that has about 30 values within that column. I want to avg only certain values within the Reasons column.</P><P></P><P>Column&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Reasons&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ID (thds of values)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>OT (include in AVG)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>PTO (include in AVG)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>VTO (exclude in AVG)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>UTPO (exclude in AVG)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40</P><P></P><P>Output</P><P>AvgReasons</P></BODY></HTML> Tue, 14 Jun 2016 15:15:54 GMT https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113277#M909254 Anonymous 2016-06-14T15:15:54Z Re: Avg Multiple conditions in chart and script https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113278#M909255 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use below expression.</P><P></P><P><SPAN style="color: #993366;"><STRONG style="font-family: arial,helvetica,sans-serif;">=Avg({&lt;REASON -= {'VTO', 'UTPO'}&gt;} Value)</STRONG></SPAN></P></BODY></HTML> Tue, 14 Jun 2016 15:52:35 GMT https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113278#M909255 krishnacbe 2016-06-14T15:52:35Z Re: Avg Multiple conditions in chart and script https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113279#M909256 <HTML><HEAD></HEAD><BODY><P>Got it! One more question <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I have two conditions that I need met. The 2nd, Status = Closed. Can that be added in the expression?</P><P></P><P></P><P><SPAN style="font-size: 14pt;">=</SPAN><SPAN style="font-size: 14pt;"><SPAN style="color: #0000ff;">Avg</SPAN>({&lt;<SPAN style="color: #800000;">DISCHARGE_REASON</SPAN> ={'','','','','',''}&gt;}<SPAN style="color: #800000;">DAYS</SPAN>) </SPAN></P></BODY></HTML> Tue, 14 Jun 2016 15:54:49 GMT https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113279#M909256 Anonymous 2016-06-14T15:54:49Z Re: Avg Multiple conditions in chart and script https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113280#M909257 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Avg({&lt;REASON -= {'VTO', 'UTPO'}, Status = {'Closed'}&gt;} Days)</STRONG></P></BODY></HTML> Tue, 14 Jun 2016 15:58:19 GMT https://community.qlik.com/t5/QlikView/Avg-Multiple-conditions-in-chart-and-script/m-p/1113280#M909257 sunny_talwar 2016-06-14T15:58:19Z