topic Re: Counting buyers that have bought last month/not bought for 3 months/not bought last 6 months in QlikView

Counting buyers that have bought last month/not bought for 3 months/not bought last 6 months

Anonymous — Fri, 11 Sep 2015 10:49:43 GMT

Hi all,

I'm trying to count the buyers that have bought first of all in the last month then the ones that havent bought in 3 months then the ones that havent bought in the last 6 or more months.

I've attached the chart I am trying to create and the expression I have so far is -

count(

if(

sum({<SOLD.YrMthSeq= {"<=$(=$(vRptYrMthSeqTY) -0) >=$(=$(vRptYrMthSeqTY) -1)"},UNIT.STOCKSTATUS = {'sold'}>} UNIT.TOTALSOLD) > 0,

BUYER.B_NO))

Inside the set analysis is the sold calendar, buyer.b_no is the unique buyers account number.

Any help would be greatly appreciated,

Thanks

Gareth

Re: Counting buyers that have bought last month/not bought for 3 months/not bought last 6 months

Gysbert_Wassenaar — Fri, 11 Sep 2015 12:45:46 GMT

Perhaps something like these:

count({<BUYER.B_NO=E({<BUYER.B_NO={'sum({<SOLD.YrMthSeq= {"<=$(=$(vRptYrMthSeqTY) -0) >=$(=$(vRptYrMthSeqTY) -3)"},UNIT.STOCKSTATUS = {"sold"}>} UNIT.TOTALSOLD) > 0'}>}BUYER.B_NO)>} BUYER.B_NO)

count({<BUYER.B_NO=E({<BUYER.B_NO={'sum({<SOLD.YrMthSeq= {"<=$(=$(vRptYrMthSeqTY) -0) >=$(=$(vRptYrMthSeqTY) -6)"},UNIT.STOCKSTATUS = {"sold"}>} UNIT.TOTALSOLD) > 0'}>}BUYER.B_NO)>} BUYER.B_NO)

Re: Counting buyers that have bought last month/not bought for 3 months/not bought last 6 months

Anonymous — Fri, 11 Sep 2015 15:35:13 GMT

Hi Gysbert,

Thanks for this are you able to explain this a little more?