topic Re: Line Chart: Show Max as a Line in QlikView https://community.qlik.com/t5/QlikView/Solved/m-p/1004860#M946764 <HTML><HEAD></HEAD><BODY><P>Or just</P><P>if(</P><P>max( total</P><P>&nbsp; Aggr(</P><P>&nbsp; COUNT( {&lt;ESTADO=-{'Anulado'}&gt;} ID ) / IF(CLAS_ID_VISTA=1, SUM(NOMI_OPERAN),SUM(NOMI_ANALISTAS))</P><P>&nbsp; , MES#_AÑO</P><P>&nbsp; )</P><P>&nbsp; ) = COUNT( {&lt;ESTADO=-{'Anulado'}&gt;} ID ) / IF(CLAS_ID_VISTA=1, SUM(NOMI_OPERAN),SUM(NOMI_ANALISTAS)) , column(1))</P><P></P><P></P><P>as expression</P></BODY></HTML> Wed, 30 Dec 2015 15:12:04 GMT Clever_Anjos 2015-12-30T15:12:04Z Solved https://community.qlik.com/t5/QlikView/Solved/m-p/1004857#M946761 <HTML><HEAD></HEAD><BODY><P>Solved</P></BODY></HTML> Wed, 30 Dec 2015 15:01:31 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1004857#M946761 microwin88x 2015-12-30T15:01:31Z Re: Line Chart: Show Max as a Line https://community.qlik.com/t5/QlikView/Solved/m-p/1004858#M946762 <HTML><HEAD></HEAD><BODY><P>Please find attached</P><P><IMG alt="Capturar.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/110318_Capturar.PNG" style="height: 164px; width: 620px;" /></P></BODY></HTML> Wed, 30 Dec 2015 15:05:36 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1004858#M946762 Clever_Anjos 2015-12-30T15:05:36Z Re: Line Chart: Show Max as a Line https://community.qlik.com/t5/QlikView/Solved/m-p/1004859#M946763 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/110316_Capture.PNG" style="height: 154px; width: 620px;" /></P><P>Expression:</P><P><STRONG>=If(Max(TOTAL Aggr(NUM( ((COUNT( {&lt;ESTADO=-{'Anulado'}&gt;} ID ) / IF(CLAS_ID_VISTA=1, SUM(NOMI_OPERAN),SUM(NOMI_ANALISTAS)))), '#.##0,0' ), [MES#_AÑO])) = NUM(((COUNT( {&lt;ESTADO=-{'Anulado'}&gt;} ID ) / IF(CLAS_ID_VISTA=1, SUM(NOMI_OPERAN),SUM(NOMI_ANALISTAS)))), '#.##0,0'),</STRONG></P><P><STRONG>&nbsp; NUM( ((COUNT( {&lt;ESTADO=-{'Anulado'}&gt;} ID ) / IF(CLAS_ID_VISTA=1, SUM(NOMI_OPERAN),SUM(NOMI_ANALISTAS)))), '#.##0,0' ))</STRONG></P></BODY></HTML> Wed, 30 Dec 2015 15:07:58 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1004859#M946763 sunny_talwar 2015-12-30T15:07:58Z Re: Line Chart: Show Max as a Line https://community.qlik.com/t5/QlikView/Solved/m-p/1004860#M946764 <HTML><HEAD></HEAD><BODY><P>Or just</P><P>if(</P><P>max( total</P><P>&nbsp; Aggr(</P><P>&nbsp; COUNT( {&lt;ESTADO=-{'Anulado'}&gt;} ID ) / IF(CLAS_ID_VISTA=1, SUM(NOMI_OPERAN),SUM(NOMI_ANALISTAS))</P><P>&nbsp; , MES#_AÑO</P><P>&nbsp; )</P><P>&nbsp; ) = COUNT( {&lt;ESTADO=-{'Anulado'}&gt;} ID ) / IF(CLAS_ID_VISTA=1, SUM(NOMI_OPERAN),SUM(NOMI_ANALISTAS)) , column(1))</P><P></P><P></P><P>as expression</P></BODY></HTML> Wed, 30 Dec 2015 15:12:04 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1004860#M946764 Clever_Anjos 2015-12-30T15:12:04Z