topic Comon Customer Problem Urgent in QlikView

Comon Customer Problem Urgent

Wed, 22 Feb 2012 07:01:38 GMT

Hello All,

I need a help as you can see in the image above i need a Number of common customer who have done purchasing across consecutive Months.

Like for Jan/Feb/Mar,it should customers who have done shopping in all the three months January ,february and March.

Plz do let me know if you need more information.

PFA the sample data

Regards,

Yashpal SIngh Rawat

Comon Customer Problem Urgent

CELAMBARASAN — Wed, 22 Feb 2012 07:28:48 GMT

Hi,

I think you can do this by creating 12 expression without dimension and it depends maximum date?

is it ok for your requirement?

Celambarasan

Comon Customer Problem Urgent

Wed, 22 Feb 2012 07:53:54 GMT

Hello Celambarasan

Plz could you write a single expression so that i can implement the same for 12 expression. yashpal singh

Comon Customer Problem Urgent

CELAMBARASAN — Wed, 22 Feb 2012 09:25:22 GMT

Hi,

Check with this.

Have a variable with value as

vCustomers = Concat({<Date={'>=$(=MonthStart(Max(Date),$1))<=$(=MonthEnd(Max(Date),$2))'}>} CustomerID,',')

=Sum({<CustomerID={$(=vCustomers(0,0))}*{$(=vCustomers(-1,-1))'}*{$(=vCustomers(-2,-2))'}, Date={">=$(=MonthStart(Max(Date),-2))<=$(=MonthEnd(Max(Date),0))"}>} CustomerID,','))},Year=,Month=,MonthYear=>} Sales)

>=$(=MonthStart(Max(Date),-2))<=$(=MonthEnd(Max(Date),0)) in this instead of 2 use 3 and instead of 0 use 1.

Continue this up to 12 and 10

vCustomers(-1,-1) ,vCustomers(-2,-2),vCustomers(-3,-3) for next expr and keeps on going.

Celambarasan