Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
alexandernatale
Creator II
Creator II

Difference between dimensions and time series

Hello,

I have a problem that I can't solve. I have a table made up of:

| date | Country | ValueDimension 1 | ValueDimension 2 |

I want to represent on a graph, for each country, the daily difference of the sum of ValueDimension1 and ValueDimension2

 

 

(ValueDimension1 [Day 2] + ValueDimension2 [Day 2] - {ValueDimension1 [Day1] + ValueDimension2 [Day1]}

 

 

 

I have tried with:

 

 

sum (ValueDimension1) + sum (ValueDimension2) - (Above (sum (ValueDimension1) + sum (ValueDimension2)), 1)

 

 

but what it creates is an "unordered" difference. How can I solve it?

 

Thank you all

1 Solution

Accepted Solutions
alexandernatale
Creator II
Creator II
Author

I'm sorry for that but I tried the solution.

 

In the "Measures", there is an option to calculate the expression: the modificator. In the option there is "difference".

Schermata 2020-04-03 alle 23.26.51.png

 

Schermata 2020-04-03 alle 23.28.04.png

 

View solution in original post

1 Reply
alexandernatale
Creator II
Creator II
Author

I'm sorry for that but I tried the solution.

 

In the "Measures", there is an option to calculate the expression: the modificator. In the option there is "difference".

Schermata 2020-04-03 alle 23.26.51.png

 

Schermata 2020-04-03 alle 23.28.04.png