Re: Same Store Sales - Qlik Community

manojkulkarni · ‎2015-09-10

Hi All,

I need to create a chart to show the growth over 12 months for same store sales. How can we do this ?

vikasmahajan · ‎2015-09-10

WHAT IS EXACT REQUIREMENT ????????????

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

manojkulkarni · ‎2015-09-10

Would like to build a chart to show the sales of same stores which were present in both the periods.

vikasmahajan · ‎2015-09-10

that means Current Vs Last yr ???

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

manojkulkarni · ‎2015-09-10

any period,

CY vs LY

Current Year Current Month vs Last Year Same Month etc..

But the thing is, sales should be taken only from the common stores of both the periods

vikasmahajan · ‎2015-09-10

Compare current sum Rev VS last year sum Rev

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2015-09-10

take dimension as store

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

manojkulkarni · ‎2015-09-10

this will not work. Will send across sample data with expected result.

vikasmahajan · ‎2015-09-11

Request you to create small demo to help you better ..........

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

manojkulkarni · ‎2015-09-11

Pls find attached excel with test data & as well expected result