topic Re: Like-for-like Advanced Comparison Method in QlikView

Like-for-like Advanced Comparison Method

vadim_grab — Mon, 30 Jan 2017 06:46:49 GMT

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

Re: Like-for-like Advanced Comparison Method

sdmech81 — Mon, 30 Jan 2017 07:20:10 GMT

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

Re: Like-for-like Advanced Comparison Method

vadim_grab — Mon, 30 Jan 2017 09:53:03 GMT

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

Re: Like-for-like Advanced Comparison Method

sdmech81 — Mon, 30 Jan 2017 10:36:58 GMT

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

Re: Like-for-like Advanced Comparison Method

vadim_grab — Mon, 30 Jan 2017 13:00:59 GMT

Sachin,

Please see attached file (Excel Example)

Vadim

Re: Like-for-like Advanced Comparison Method

rwunderlich — Mon, 30 Jan 2017 22:56:27 GMT

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

-Rob

Re: Like-for-like Advanced Comparison Method

vadim_grab — Wed, 01 Feb 2017 10:25:04 GMT

Thanks, Rob.

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

Maybe I misunderstood?

Vadim