topic pivot table get sales difference about weeks in QlikView

pivot table get sales difference about weeks

sedalinda — Sun, 22 Jan 2023 18:05:40 GMT

Hello guys,

ı need help for qliksense enterprise edition platform.

ı have pivot table for sales persons, country, salesweeks data.

sales person and country is dimension and rows.

salesweeks is a column, measure is price in pivot table.

WEEK1 WEEK2 WEEK3 WEEK4 WEEK5 in below picture.

ı need to calculate WEEK1-WEEK2 price, WEEK2-WEEK3 price , calculate difference gap

how can I do this in frontend, please help me.

Thank you very much.

Re: pivot table get sales difference about weeks

jcmachado — Wed, 25 Jan 2023 21:01:43 GMT

You can use the "Expression Editor" in QlikSense to create a new measure that calculates the difference between the prices of consecutive weeks. Here's an example of how you can do this:

Go to the "Properties" pane of your pivot table and select the "Expressions" tab.
Click on the "+" button to add a new expression.
Name the expression "Week1-Week2" and enter the following formula: =SUM(IF([Week] = 'Week1', [Price], 0)) - SUM(IF([Week] = 'Week2', [Price], 0))
Create another expression and name it "Week2-Week3" and enter the following formula: =SUM(IF([Week] = 'Week2', [Price], 0)) - SUM(IF([Week] = 'Week3', [Price], 0))
You can also create another expression to calculate the difference gap between weeks by using the above expressions. =(Week1-Week2) - (Week2-Week3)
Add the new expressions to the pivot table by dragging them from the "Expressions" tab to the "Columns" or "Rows" sections.

You should now have a pivot table that shows the difference in prices between consecutive weeks for each salesperson and country.

Please note that this is just an example, you might want to adjust the formula according to your data and needs.

Re: pivot table get sales difference about weeks

sedalinda — Sat, 28 Jan 2023 12:56:00 GMT

than you very much. In same time I user before script for do this.