topic Re: how to get zero value customers in QlikView

how to get zero value customers

Tue, 09 Jul 2013 21:37:57 GMT

i have a list of customers and sales. requirement is to display customers who has no sales in last 6 months. can some one help me with some idea to achieve this.

Re: how to get zero value customers

MayilVahanan — Tue, 09 Jul 2013 23:15:38 GMT

Try like this

vDate1 = MonthStart(Max(DateField),-5)

vDate2 = Max(DateField)

Make sure that, date field is same.

Count({<DateField= {'>=$(=vDate1)<=$(=vDate2)'}, Sales -= {'*'}>} Customers)

Count({<DateField= {'>=$(=vDate1)<=$(=vDate2)'}, Sales = {0}>} Customers)

Hope it helps

Re: how to get zero value customers

Wed, 10 Jul 2013 15:27:01 GMT

Thank you mayil, i didn't work this way. i got it to work using calculated dimensin with

=if(aggr(sum({<$(tDim)=$(vMonthWeek)>}Sales),Customer)=0,Customer,null())