Discussion board where members can get started with Qlik Sense.
Hi, I would like to ask how can I generate the "Div." and "Div. (%)" based on "Quarter 1"?
Div: Sum(Field) - Above(Sum(Field), 1, 1)
Div (%): (Sum(Field) - Above(Sum(Field), 1, 1)) / Above(Sum(Field), 1, 1))
View solution in original post
There are many options to compare the sales of this year to last year. For example, you could use a table with the following:
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.
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).
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.
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.
Thanks a lot TimvB, it does resolved my problem.