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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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