Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Simple question about the use of functions "above" and "sum"

Hi,

Assume that I've these table :

EnergyTouch046.jpg

If I select the device 1 and I plot this chart :

     Dimension : time

     Expression : value-above(value)

I get what I want (even if the first value is NULL)

Now, if I select device 1 and 2 and I plot this chart :

     Dimension : time

     Expression : Sum(value-above(value))

I get : No data to display

I think it is a problem of the return value of above and the use of sum ... I am sure u have an idea

Have a nice day

Jérémy

1 Solution

Accepted Solutions
Not applicable
Author

Hi Jeremy,

Please, take a look into attached example.

Is it what you are trying to achieve?

Kind regards,
Janusz

View solution in original post

2 Replies
Not applicable
Author

Hi Jeremy,

Please, take a look into attached example.

Is it what you are trying to achieve?

Kind regards,
Janusz

Not applicable
Author

Hi Janusz,

this is not exactly what i want. I've detailled there :

EnergyTouch047.jpg

Dzienkuje

Jérémy