topic Avg If or AGGR in App Development

topic Avg If or AGGR in App Development https://community.qlik.com/t5/App-Development/Avg-If-or-AGGR/m-p/127609#M8929 <HTML><HEAD></HEAD><BODY><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">Hi all,</P><P></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">My table is like that and</P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">I want to calculate the average of Tx de marge </SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><BR style="font-family: &font-size:13px; font-style: normal; font-weight: 400; border-color: #3d3d3d; border-style: none;" /></SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">but </SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><BR style="font-family: &font-size:13px; font-style: normal; font-weight: 400; border-color: #3d3d3d; border-style: none;" /></SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">I want all the value if [début de contrat] <31/08/2018</SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><BR style="font-family: &font-size:13px; font-style: normal; font-weight: 400; border-color: #3d3d3d; border-style: none;" /></SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">and</SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><BR style="font-family: &font-size:13px; font-style: normal; font-weight: 400; border-color: #3d3d3d; border-style: none;" /></SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">I Don't want to take the value if [date fin contrat <31/08/2018 and if Matricule facturation = INTERNE</SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><A _jive_internal="true" data-containerid="-1" data-containertype="-1" data-objectid="213573" data-objecttype="111" href="https://community.qlik.com/servlet/JiveServlet/downloadImage/2-1546167-213573/Capture qlik 3.JPG" style="color: #3778c7; font-family: &font-size:13px; font-style: normal; font-weight: 400; border-color: #3778c7; border-style: none;"></A></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><A href="/legacyfs/online/213584_Capture qlik 3.JPG"></A></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">Thanks for your help</P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><IMG alt="Capture qlik 3.JPG" class="jive-image image-1" src="/legacyfs/online/213585_Capture qlik 3.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 14 Sep 2018 10:24:50 GMT Anonymous 2018-09-14T10:24:50Z Avg If or AGGR https://community.qlik.com/t5/App-Development/Avg-If-or-AGGR/m-p/127609#M8929 <HTML><HEAD></HEAD><BODY><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">Hi all,</P><P></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">My table is like that and</P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">I want to calculate the average of Tx de marge </SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><BR style="font-family: &font-size:13px; font-style: normal; font-weight: 400; border-color: #3d3d3d; border-style: none;" /></SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">but </SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><BR style="font-family: &font-size:13px; font-style: normal; font-weight: 400; border-color: #3d3d3d; border-style: none;" /></SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">I want all the value if [début de contrat] <31/08/2018</SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><BR style="font-family: &font-size:13px; font-style: normal; font-weight: 400; border-color: #3d3d3d; border-style: none;" /></SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">and</SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><BR style="font-family: &font-size:13px; font-style: normal; font-weight: 400; border-color: #3d3d3d; border-style: none;" /></SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><SPAN style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">I Don't want to take the value if [date fin contrat <31/08/2018 and if Matricule facturation = INTERNE</SPAN></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><A _jive_internal="true" data-containerid="-1" data-containertype="-1" data-objectid="213573" data-objecttype="111" href="https://community.qlik.com/servlet/JiveServlet/downloadImage/2-1546167-213573/Capture qlik 3.JPG" style="color: #3778c7; font-family: &font-size:13px; font-style: normal; font-weight: 400; border-color: #3778c7; border-style: none;"></A></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><A href="/legacyfs/online/213584_Capture qlik 3.JPG"></A></P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;">Thanks for your help</P><P style="color: #3d3d3d; font-family: &font-size:13px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px; border-color: #3d3d3d; border-style: none;"><IMG alt="Capture qlik 3.JPG" class="jive-image image-1" src="/legacyfs/online/213585_Capture qlik 3.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 14 Sep 2018 10:24:50 GMT https://community.qlik.com/t5/App-Development/Avg-If-or-AGGR/m-p/127609#M8929 Anonymous 2018-09-14T10:24:50Z