topic Re: Same Store Sales in QlikView

Same Store Sales

manojkulkarni — Thu, 10 Sep 2015 11:12:22 GMT

Hi All,

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

Re: Same Store Sales

vikasmahajan — Thu, 10 Sep 2015 12:10:19 GMT

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

Re: Same Store Sales

manojkulkarni — Thu, 10 Sep 2015 12:19:06 GMT

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

Re: Same Store Sales

vikasmahajan — Thu, 10 Sep 2015 12:33:36 GMT

that means Current Vs Last yr ???

Re: Same Store Sales

manojkulkarni — Thu, 10 Sep 2015 12:35:19 GMT

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

Re: Same Store Sales

vikasmahajan — Thu, 10 Sep 2015 12:41:38 GMT

Compare current sum Rev VS last year sum Rev

Re: Same Store Sales

vikasmahajan — Thu, 10 Sep 2015 12:42:04 GMT

take dimension as store

Re: Same Store Sales

manojkulkarni — Thu, 10 Sep 2015 15:35:44 GMT

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

Re: Same Store Sales

vikasmahajan — Fri, 11 Sep 2015 04:38:35 GMT

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

Vikas

Re: Same Store Sales

manojkulkarni — Fri, 11 Sep 2015 05:44:18 GMT

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

Re: Same Store Sales

vikasmahajan — Fri, 11 Sep 2015 07:20:25 GMT

PFA solution

vikas

Re: Same Store Sales

sunny_talwar — Fri, 11 Sep 2015 08:10:35 GMT

Not sure what Vikas has provided (as I am working with Personal Edition of QlikView), here is another possible solution:

Expression for 2014:

=Sum({<Year = {2014}>}If(Aggr(Count(DISTINCT {<Year = {2014}>} StoreID), StoreID, Month) = Aggr(Count(DISTINCT {<Year = {2015}>} StoreID), StoreID, Month), Sales))

Expression for 2015:

=Sum({<Year = {2015}>}If(Aggr(Count(DISTINCT {<Year = {2014}>} StoreID), StoreID, Month) = Aggr(Count(DISTINCT {<Year = {2015}>} StoreID), StoreID, Month), Sales))