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 Grab Added Example for clear understanding
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..
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...
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)
Hope this clears you doubt.This analytics can be done in Qlikview!