Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vadim_grab
Creator
Creator

Like-for-like Advanced Comparison Method

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

hicjohnwstalwar1rwunderlichahaahaaha

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

6 Replies
sdmech81
Specialist
Specialist

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
Creator
Creator
Author

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
Specialist
Specialist

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
Creator
Creator
Author

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
Creator
Creator
Author

Thanks, Rob.

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

Maybe I misunderstood?

Vadim