Platform

Qlik Sense

QS Version

New Features & Enhancements

New Analysis introduced

• ITR & GMROI Report at Organization level, Product Level and Summary   

• Markup Analysis

New Dimensions and Measures added

Performance Tuning

Generic Logical Change

Bug Fixes

Through out the Application

1

Module Name : Stock Analysis

1.1) Warehouse Stock (both Qty and Amount) has been added as measure

in all classical reports under “Sales Stock” and “Stock Movement” tab as “WH Cl.

Stock Qty” and “WH Cl. Stock Amt”.

1.2) Creation Date, First In Date and Last In Date (for both Sale and Stock)

have been added as dimension in all classical reports under “Stock Ageing” and

“Sales Stock” tab as “Stock Creation Date”, “Stock First In Date”, “Stock Last In

Date”, “Sale Creation Date”, “Sale First In Date” and “Sale Last In Date” .

1.3) Two new measures named “Actual Sale Qty” and “Actual Sale Amt”

have been added as measure in all classical reports under “Sales Stock” and

“Stock Movement” tab as “Actual Qty” and “Actual Value”.

Logic of the following two measures are as follows.

Actual Sale Qty = Sale Qty + Sale Return Qty

Actual Sale Amt = Net Sale Amt + Sale Return Amt

1.4) Misc Issue and Adjustment (for both Qty and Amount) have been

added as measure in all classical reports under “Stock Movement” tab as

“Adjustment Qty”, “Adjustment Amt”, “Misc Issue Qty” and “Misc Issue Amt”.

1.5) A new and major analysis has been introduced in this version under

Stock Analysis module as “ITR & GMROI”. This analysis is based on ITR and

GMROI. It is available for four different time dimension (YTD, QTD, MTD and

Period) on Organization level, Product Level and Summary.

2

Module Name : Product Analysis

2.1) Warehouse Stock (both Qty and Amount) has been added as measure

in all classical reports under “Non Moving”, “Slow Moving”, “Fast Moving”,

“Private Brand” and “New Item” tab as “WH Cl. Stock Qty” and “WH Cl. Stock

Amt”.

2.2) Creation Date, First In Date and Last In Date (for both Sale and Stock)

have been added as dimension in all classical reports under “Non Moving”,

“Slow Moving”, “Fast Moving”, “Private Brand” and “New Item” tab as “Stock

Creation Date”, “Stock First In Date”, “Stock Last In Date”, “Sale Creation Date”,

“Sale First In Date” and “Sale Last In Date”.

3

Module Name : Supply Chain Analysis

3.1) Warehouse Stock (both Qty and Amount) has been added as measure

in all classical reports under “Product Shuffling” tab as “WH Cl. Stock Qty” and

“WH Cl. Stock Amt”.

4

Module Name : Merchandise Analysis

4.1) Warehouse Stock (both Qty and Amount) has been added as measure

in all classical reports under “OTB Analysis” and “Vendor Analysis” tab as “WH

Cl. Stock Qty” and “WH Cl. Stock Amt”.

4.2) All classical reports under Merchandise module are available in both

Pivot report and Sort Report format. Pivot report has the cross tab feature and

Sort report is for table format and for sorting on any column as per client choice.

4.3) PO Issue and PO Receive (for both Qty and Amount) have been added

as measure in all classical reports under “Purchase Analysis” tab as “PO Issue

Qty”, “PO Issue Amt”, “PO Receive Qty” and “PO Receive Amt”.

5

Module Name : Margin Analysis

5.1) A new and major analysis has been introduced in this version under

Margin Analysis module as “Markup Analysis”. Markup is the difference

between the cost of the item and the original retail price (what the item is

selling for). It is available for four different time dimension (YTD, QTD, MTD

and Period). From this analysis user can identify the correctness of expected

Markup%, also they can identify store wise, product wise markup sale, markup

margin. Margin related all measures are available in this analysis.

6

Module Name : Price Point Analysis

6.1) Warehouse Stock (both Qty and Amount) has been added as measure

in all classical reports under “Score Card” tab as “WH Cl. Stock Qty” and “WH Cl.

Stock Amt”.

6.2) Closing Stock (both Qty and Amount) has been added as measure in

all classical reports under “Score Card” tab as “Closing Stock Qty” and “Closing

Stock Amt”

7

Module Name : Report Builder

7.1) Warehouse Stock (both Qty and Amount) has been added as measure

in all classical reports under this module as “WH Cl. Stock Qty” and “WH Cl.

Stock Amt” for the six different time dimension (YTD, QTD, MTD, WTD, Daily

and Period).

7.2) Warehouse Purchase (both Qty and Amount) has been added as

measure in all classical reports under this module as “WH Purchase Qty” and

“WH Purchase Amt” for the six different time dimension (YTD, QTD, MTD, WTD,

Daily and Period).

7.3) Local Purchase (both Qty and Amount) has been added as measure in

all classical reports under this module as “Site Purchase Qty” and “Site Purchase

Amt” for the six different time dimension (YTD, QTD, MTD, WTD, Daily and

Period).

7.4) Creation Date, First In Date and Last In Date (for both Sale and

Stock) have been added as dimension in all classical reports under this module

as “Stock Creation Date”, “Stock First In Date”, “Stock Last In Date”, “Sale

Creation Date”, “Sale First In Date” and “Sale Last In Date” .

7.5) A new dimension is introduced in this version is “Age”. It is a

calculative dimension. It is calculated based on creation date, first in date and

last in date. It has been added as dimension in all classical reports under this

module as “Age”.

7.6) There are four basic fields are added as dimension in all classical

reports under this module as “Day”, “Date” ,“Sale Type” and “Site Class” for the

six different time dimension (YTD, QTD, MTD, WTD, Daily and Period).

7.7) A new measure has been added in all classical reports under this

module as “Discounted_Amt%” for the six different time dimension (YTD, QTD,

MTD, WTD, Daily and Period). It is a calculative measure. To generate in report

please select “Discounted Sale Amt” from select measure option.

Logic of the following two measures are as follows.

Discounted_Amt% = Discounted Sale Amount / Net Sale Amount

8

Module Name : All over Application

8.1) In this version we have changed and updated UI design through out

the application.

8.2) We have tuned up the application for better performance.

8.3) As per the latest version of Qlik Sense, we have used so many new

features and chart objects in this version for better performance.

1

All expressions of Periodical Markdown Analysis Report have been

updated .

2

Expressions of all KPI’s under Stock Ageing Dashboard have been

updated.