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

Consecutive values

Hi to all,

       that’s my first post on this wonderful forum, I’m quite new on Qlik.

That’s my little question.

I have a table.

a.PNG.png

In this table I’d like to add a new dimension that should be the difference between two consecutives values with the idea that the first one is not calculable.

b.PNG.png

Thanks in advance for your attention

Angelo

1 Solution

Accepted Solutions
maxgro
MVP
MVP

add an expression

sum([Trend customer]) - above(sum([Trend customer]))

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Ciao Angelo,

esistono delle funzioni sia a livello di script che di layout:

guarda le funzioni Previous e Above, guarda quella che fa al caso tuo e fammi sapere.

Ciao

maxgro
MVP
MVP

add an expression

sum([Trend customer]) - above(sum([Trend customer]))

Anonymous
Not applicable
Author

Mille Grazie Angelo