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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
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