Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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