topic Difference between values of the same column in QlikView

Difference between values of the same column

matbelli — Wed, 25 Nov 2020 16:16:04 GMT

Hi, i have a column like the one on the left and i need it like the one on the right:

How can i calculate Delta?

thanks

miguelbraga — Thu, 17 Jan 2019 11:08:25 GMT

Hey there,

The correct formula is something like this:

if(isnull(Sum(F1) - Above(Total Sum(F1))), Sum(F1), Sum(F1) - Above(Total Sum(F1)))

Substitute F1 to you field.

Please, see the results in the attached file.

Best regards,

matbelli — Thu, 17 Jan 2019 11:33:35 GMT

My field was an expression, it was today()-max(Giorno_prec), if i put this instead of F1 it says "Error in expression" how can i fix it?

sunny_talwar — Thu, 17 Jan 2019 12:17:13 GMT

Try this

RangeSum(
(Today() - Max(Giorno_prec)),
-Above(Today() - Max(Giorno_prec))
)

Or this

RangeSum(
(Today() - Max(Giorno_prec)),
-Above(TOTAL Today() - Max(Giorno_prec))
)

amskeith — Fri, 20 Dec 2019 17:24:25 GMT

This worked for an issue I was having! Just make sure you add both expressions to the chart and everything will calculate as needed. Thank you!