Same Store Sales

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

PFA solution

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.

sunny_talwar · ‎2015-09-11

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

Related Topics