# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for
Search instead for
Did you mean:
Highlighted
Contributor III

## Qlik Sense sales previous year comparison

Hi, I would like to ask how can I generate the "Div." and "Div. (%)" based on "Quarter 1"?

 Year Quarter 1 Div. Div. (%) 2012 100.00 - 0.0% 2013 200.00 100.00 100.0% 2014 175.00 -          25.00 -12.5% 2015 225.00 50.00 28.6% 2016 250.00 25.00 11.1%
Labels (1)
• ### Qlik Sense

1 Solution

Accepted Solutions
Highlighted
Creator II

Div: Sum(Field) - Above(Sum(Field), 1, 1)

Div (%): (Sum(Field) - Above(Sum(Field), 1, 1)) / Above(Sum(Field), 1, 1))

4 Replies
Creator II

There are many options to compare the sales of this year to last year. For example, you could use a table with the following:

Table:

Dimension: any sales related (product, department, sales employees, etc.)

Measures: Total Sales LY, Sales LYTD, Sales YTD, Difference YTD-LYTD, Grow percentage (LYTD-YTD)/LYTD, etc.

Line chart:

X-axis dimension: time related such as month, quarter, week.

Measures: sum of sales of last year (red) and the sum of sales this year (blue).

Bar chart:

Dimension: any sales related dimension (product category, etc.)

Measures: sum sales LYTD (red) and sum sales (YTD) blue.

I hope this gives you some inspiration.

Highlighted
Contributor III

Hi TimvB, sorry maybe my question is not clear enough. Maybe I should ask, how to generate the "Div" and "Div (%)" based on the Quarter 1 data.

Highlighted
Creator II

Div: Sum(Field) - Above(Sum(Field), 1, 1)

Div (%): (Sum(Field) - Above(Sum(Field), 1, 1)) / Above(Sum(Field), 1, 1))

Highlighted
Contributor III

Thanks a lot TimvB, it does resolved my problem.