topic Re: Sales values zero current Month in Brasil

Sales values zero current Month

MarioCenteno — Wed, 25 Jul 2018 21:47:28 GMT

Good afternoon, I need you to help me solve this problem:

I need to show only sales with zero value of the current month and then compare it with the sales average of the last 3 months.

Re: Sales values zero current Month

BalaBhaskar_Qlik — Thu, 26 Jul 2018 09:11:43 GMT

Think so,

Current month Sales with zero value

Sum({$<Sales = {'0'}, Month={'$(=Month(max(Date)))'}>}[Sales])

Previous 3 months sales:

=Sum({<Sales = {'0'}, Date={">=$(=MonthStart(AddMonths(Max(Date),-3)))<=$(=MonthEnd(AddMonths(Max(Date),-1)))"}>}Sales)

Re: Sales values zero current Month

MarioCenteno — Fri, 27 Jul 2018 04:40:33 GMT

Thanks for answering he resolved the current month and last 3 months, now the problem is that I have to put myself in the dimension of the same condition and that I show the clients with zero sales I am using a function but something I am doing wrong.

Current month ---> ok

SUM({$<[SALES]=0,[FECHA_PROCESO.autoCalendar.Date]=

{'>=$(=AddMonths(Today(),-1))<=$(=AddMonths(Today(),+1))'}>}SALES)

Previous 3 month sales ---> ok

SUM({$<[FECHA_PROCESO.autoCalendar.Date]=

{'>=$(=AddMonths(Today(),-4))<=$(=AddMonths(Today(),-1))'}>}SALES/3)

Dimension --- not working

=if( aggr((SUM({$<[SALES]=0,[FECHA_PROCESO.autoCalendar.Date]=

{'>=$(=AddMonths(Today(),-1))<=$(=AddMonths(Today(),+1))'}>}SALES)),NOMBRE_CLIENTE)=0, NOMBRE_CLIENTE,'Otros Clientes')

Re: Sales values zero current Month

BalaBhaskar_Qlik — Fri, 27 Jul 2018 05:07:44 GMT

You created your expression like this, Your setting the Aggr value with zero, may be that is causing the issue.

=If(Aggr(Sum({<Sales=,Date=>}),Nombre_Cliente)=0,Nombre_cliente,'Otros Clientes')

Try to change your expression like these....

=If(Count(Aggr(Sum({<Sales=,Date=>}),Nombre_Cliente))=0,Nombre_cliente,'Otros Clientes')

=If(Min(Aggr(Sum({<Sales=,Date=>}),Nombre_Cliente))=0,Nombre_cliente,'Otros Clientes')

=If(Avg(Aggr(Sum({<Sales=,Date=>}),Nombre_Cliente))=0,Nombre_cliente,'Otros Clientes')

Re: Sales values zero current Month

MarioCenteno — Fri, 27 Jul 2018 06:20:04 GMT

Not working

Re: Sales values zero current Month

pablolabbe — Mon, 30 Jul 2018 03:01:53 GMT

Try this way with the if inside the aggr

=aggr(

IF( SUM({$<[SALES]=0,[FECHA_PROCESO.autoCalendar.Date]=

{'>=$(=AddMonths(Today(),-1))<=$(=AddMonths(Today(),+1))'}>}SALES)) = 0, NOMBRE_CLIENTE,'Otros Clientes')

,NOMBRE_CLIENTE)