Like-for-like Advanced Comparison Method

[vadim_grab]

Dear, Experts.

How do you use Like-for-Like Comparison Method in your projects?

I mean more advanced uses than  simple date periods compare...

I'm working on L4L Customer/Product Sales compare and will be thankful any feedbacks and practice share

Many thanks for your share experience.

Vadim

hic‌johnw‌stalwar1‌rwunderlich‌ahaahaaha‌

Сообщение отредактировано: Vadim Grab Added Example for clear understanding

[sdmech81]

like to like comp of dates ??

U mean like suppose u select 1/1/2017 then u want to compare the data with 1/1/2016??

If so this can be done using dynamically changing the values in variables.

If not please give little more clarity..

Sachin

[vadim_grab]

Sachin, hi

Yes, but with a focus on customers who bought in  both periods.

"like to like comp of dates" , which may include as already working, new and not working yet customers and must be cleaned off by these customers...

I mean Compare Dates with correct customer/product parts in it

And it's wil be pure L4L comp...

I  hope my English is not so bad and  I explained the idea correctly...

Vadim

[sdmech81]

Hi,

Hard to explain here this in detail here.But giving example by comparing sales of This QTR to Prev QTR (Here it apple to apple comparison, for u L4L )

Created variables as below:

vMaxDate=date(max(OrderDate))   ----> fetches max date
vQtr_Start=QuarterStart(max(OrderDate))  ----->fetches current Qtr start date

vPrev_Qtr_Start=AddMonths((vQtr_Start), -3)  ----->Fteches Prev QTr start date
vPrev_Qtr_End=AddMonths((vMaxDate),-3)    ----->Observe used VmaxDate so that number of days comparison in both QTR shoul be same (L4L /apple to apple comp)..

Then using below set you can compare the count/sale any aggrgn by passing above variables.This is QTD.

Similarly YTD,MTD can be done  (like wise by altering var and set you can even compare Qtr exit day of present and prev Qtr also which compares takes only 1day comp)

count({$<OrderDate={'>=$(vQtr_Start) <=$(vMaxDate)'}>}DISTINCT(Items))

count({$<OrderDate={'>=$(vPrev_Qtr_Start) <=$(vPrev_Qtr_End)'}>}DISTINCT(Items))

Hope this clears you doubt.This analytics can be done in Qlikview!

Sachin

[vadim_grab]

Sachin,

Please see attached file (Excel Example)

Vadim

[rwunderlich]

You can use the p() set operator to enable same-store or same-customer type analysis.

-Rob

[vadim_grab]

Thanks, Rob.

One question - what about p() and >1000 Customers comp?

Maybe I misunderstood?

Vadim