topic Re: Monitoring No Sales Events in QlikView

Monitoring No Sales Events

Anonymous — Wed, 04 Apr 2012 21:16:26 GMT

I would like to look back 3 months for no sale activity on a given sale item that sold in the current month . This would allow me to flag it as a A new sale. In the example I've attached sample of a pivot table I am working with Item LEM 24L would qualify as a new sale since 3 months prior May Jun and Jul there was no sales. . I have tried creating LastThreeMonthFlag but it does not seem to work see script. Any assistance would be appreciated.

Monitoring No Sales Events

Wed, 04 Apr 2012 21:44:25 GMT

Something like below. Note: You might need to use a date field and do Monthname(Datefield) to order your months correctly for this to work.

if(rangesum(Before(sum(distinct UnitSold),1,3))=0, sum(distinct UnitSold))

Re: Monitoring No Sales Events

Anonymous — Wed, 04 Apr 2012 22:57:00 GMT

Hi Marcsliving

As suggested I used a correctly sorted monthyear ( datefield) and it worked beautifully exactly what I was looking for .

Thanks so much

Regards

Mike