topic Re: Like for Like Sales in QlikView

Like for Like Sales

Tue, 09 Apr 2013 14:39:48 GMT

I am wanting to include like for like analysis in an existing Sales report I am working on. This currently shows sales per store.

QVW user selects the Date range for the report either by selecting Financial Year, Period, Week or Date Values or any combination of these list boxes.

I would like to either;

1. include a button that switches the report from all stores to like for like data.

2.Or if this cannot be done then available - data in a table along the following lines;

Sales All 2011	Sales All 2012	Stores All	L4L Sales 2011	L4L Sales 2012	No of Stores

Like for like - for the selected date range only show data for Stores that were open and sending in sales data for that date range and also for the comparison date range ie , Same Week Last Year, Last Period, Last Financial Year.

Hope you can help - I hsve tried alsorts of ideas available on the community but none seem to address my issue.

Many thanks in advance

Re: Like for Like Sales

Mon, 15 Apr 2013 13:06:50 GMT

Any response on this one pls

Re: Like for Like Sales

Anonymous — Tue, 15 Oct 2013 19:28:28 GMT

Like for Like Sales

There are a number of approaches to creating Like-for-Like sales analysis. The easiest, and far the least (RAM) resource intensive, is to create Flags in the dataset. The calculation of the Flags will depend upon the type of "Like-for-Like" that you are trying to calculate (i.e. if it is same Date or same Day last period), but it's a simple appraoch.

The attached is an example of the approach which I posted in response to another similar Question http://community.qlik.com/message/274880#274880

It is possible to make the Calculation dynamic (to create a button) by creating an Inline Table and a Variable.

The example is very simple, but I hope it helps you get started with your Like For Like analysis.