Like for Like (L4L) Store analyse

[makkemik]

Hello All,

I have 4 main Table; 1st Products table , 2nd Stores Table (included opening and closing dates by store), 3rd Sales transactions (nearly 2 M row) and 4th Calender Table (week, month, year, day, quarter bases).

Sales data included for 3 years. so I need to make comparison report L4L basis by Store level.

I want to see for all sales and when I click the button or select the check box it will be return L4L base.

Do you have any detailed example?

Thank you for your kindly assistant and sharing as usual.

Kind regards

Murat

[swuehl]

IMHO: The first results on a simple search look quite promising:

http://community.qlik.com/search.jspa?q=like+for+like

[makkemik]

Thank you for your kindly interest.

I have already checked from these links which you sent. I could not find the exact solution in the site. They are using flag method and in the big data it is not worked with (exist function). May be set analyze?

I'm trying to find solution.

Regards

[makkemik]

any L4L comands?