Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
Jo
Hi
Any response on this one pls
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.