topic Re: Expression % M-1 in QlikView https://community.qlik.com/t5/QlikView/Expression-M-1/m-p/1338873#M412666 <HTML><HEAD></HEAD><BODY><P>would you be able to share the sample data with expected output need?</P></BODY></HTML> Thu, 06 Jul 2017 11:21:51 GMT Kushal_Chawda 2017-07-06T11:21:51Z Expression % M-1 https://community.qlik.com/t5/QlikView/Expression-M-1/m-p/1338872#M412665 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Bonjour,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">mon besoin est de <SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">calculer</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">-&nbsp; </SPAN>le pourcentage de nb des appels :</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">% M-1= (nb de mois en cours / nb ds appels mois précédent ) -1</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">- Moyen Annuelle en nombre</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">- Moyen Annuelle en pourcentage</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">voici l'expression que j'ai utilisé</P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">count({&lt;[Ligne]={'Courrier Produits',<SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">'Tel. Produits',}&gt;} [Prise de contact])</SPAN></P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">j'ai ne trouve pas les bon chiffres,</SPAN></P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">Ci-joint le </SPAN>Screenshots de mon tableau.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">Merci à vous</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">Maurice </SPAN></P></BODY></HTML> Thu, 06 Jul 2017 11:07:58 GMT https://community.qlik.com/t5/QlikView/Expression-M-1/m-p/1338872#M412665 MauriceLudo 2017-07-06T11:07:58Z Re: Expression % M-1 https://community.qlik.com/t5/QlikView/Expression-M-1/m-p/1338873#M412666 <HTML><HEAD></HEAD><BODY><P>would you be able to share the sample data with expected output need?</P></BODY></HTML> Thu, 06 Jul 2017 11:21:51 GMT https://community.qlik.com/t5/QlikView/Expression-M-1/m-p/1338873#M412666 Kushal_Chawda 2017-07-06T11:21:51Z Re: Expression % M-1 https://community.qlik.com/t5/QlikView/Expression-M-1/m-p/1338874#M412667 <HTML><HEAD></HEAD><BODY><P>voici le fichier </P></BODY></HTML> Thu, 06 Jul 2017 11:59:42 GMT https://community.qlik.com/t5/QlikView/Expression-M-1/m-p/1338874#M412667 MauriceLudo 2017-07-06T11:59:42Z