https://community.qlik.com/t5/Brasil/Frequencia-de-compra/m-p/1616967#M57555 <P>Olá</P><P>se você tiver em uma coluna as datas das compras</P><P>pode fazer</P><P>&nbsp;</P><LI-CODE lang="markup">count(distinct monthstart(coluna_data))</LI-CODE><P>assim vai aparecer a quantidade de meses diferentes que seus clientes fizeram compras&nbsp;</P> Tue, 27 Aug 2019 10:04:13 GMT Yoshidaqlik 2019-08-27T10:04:13Z https://community.qlik.com/t5/Brasil/Frequencia-de-compra/m-p/1615016#M57515 <P>Como posso fazer para computar a frequência de compra dos meus clientes.</P><P>Quero saber em quantos meses do ano ele comprou. exemplo</P><TABLE><TBODY><TR><TD><FONT size="2">CLIENTE</FONT></TD><TD><FONT size="2">JANEIRO</FONT></TD><TD><FONT size="2">FEVEREIRO</FONT></TD><TD><FONT size="2">MARÇO</FONT></TD><TD><FONT size="2">ABRIL</FONT></TD><TD><FONT size="2">MAIO</FONT></TD><TD><FONT size="2">JUNHO</FONT></TD><TD><FONT size="2">JULHO</FONT></TD><TD><FONT size="2">FREQUENCIA COMPRA</FONT></TD></TR><TR><TD><FONT size="2">CLIENTE A</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp; 1.100,00</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp; 1.542,00</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp; 2.426,00</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp; 4.194,00</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp; 7.730,00</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp; 14.802,00</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp; 28.946,00</FONT></TD><TD><FONT size="2">7</FONT></TD></TR><TR><TD><FONT size="2">CLIENTE B</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp; 2.540,22</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp; 4.422,44</FONT></TD><TD>&nbsp;</TD><TD><FONT size="2">&nbsp;R$&nbsp; 15.715,76</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp; 30.773,52</FONT></TD><TD>&nbsp;</TD><TD><FONT size="2">&nbsp;R$&nbsp; 121.120,08</FONT></TD><TD><FONT size="2">5</FONT></TD></TR><TR><TD><FONT size="2">CLIENTE C</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp;&nbsp; 600,32</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 542,64</FONT></TD><TD>&nbsp;</TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 196,56</FONT></TD><TD>&nbsp;</TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.187,76</FONT></TD><TD>&nbsp;</TD><TD><FONT size="2">4</FONT></TD></TR><TR><TD><FONT size="2">CLIENTE D</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 658,00</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 659,00</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 660,00</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 661,00</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 662,00</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 663,00</FONT></TD><TD><FONT size="2">7</FONT></TD></TR><TR><TD><FONT size="2">CLIENTE A</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp; 5.896,32</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp; 11.134,64</FONT></TD><TD>&nbsp;</TD><TD><FONT size="2">&nbsp;R$&nbsp; 42.564,56</FONT></TD><TD>&nbsp;</TD><TD><FONT size="2">&nbsp;R$&nbsp; 168.284,24</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp; 335.910,48</FONT></TD><TD><FONT size="2">5</FONT></TD></TR><TR><TD><FONT size="2">CLIENTE C</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp;&nbsp; 185,98</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 286,04</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp; 1.230,08</FONT></TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp; 3.118,16</FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><FONT size="2">&nbsp;R$&nbsp;&nbsp;&nbsp; 29.551,28</FONT></TD><TD><FONT size="2">5</FONT></TD></TR></TBODY></TABLE> Wed, 21 Aug 2019 18:24:50 GMT https://community.qlik.com/t5/Brasil/Frequencia-de-compra/m-p/1615016#M57515 dioneicm 2019-08-21T18:24:50Z https://community.qlik.com/t5/Brasil/Frequencia-de-compra/m-p/1615613#M57526 <P>COUNT(MESES)</P> Thu, 22 Aug 2019 19:40:18 GMT https://community.qlik.com/t5/Brasil/Frequencia-de-compra/m-p/1615613#M57526 marco_almeida 2019-08-22T19:40:18Z https://community.qlik.com/t5/Brasil/Frequencia-de-compra/m-p/1616967#M57555 <P>Olá</P><P>se você tiver em uma coluna as datas das compras</P><P>pode fazer</P><P>&nbsp;</P><LI-CODE lang="markup">count(distinct monthstart(coluna_data))</LI-CODE><P>assim vai aparecer a quantidade de meses diferentes que seus clientes fizeram compras&nbsp;</P> Tue, 27 Aug 2019 10:04:13 GMT https://community.qlik.com/t5/Brasil/Frequencia-de-compra/m-p/1616967#M57555 Yoshidaqlik 2019-08-27T10:04:13Z