topic Re: Consecutive values in QlikView

Consecutive values

Anonymous — Wed, 03 Sep 2014 10:09:07 GMT

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.

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.

Thanks in advance for your attention

Angelo

Re: Consecutive values

alexandros17 — Wed, 03 Sep 2014 10:10:42 GMT

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

Re: Consecutive values

maxgro — Wed, 03 Sep 2014 10:21:06 GMT

add an expression

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

Re: Consecutive values

Anonymous — Wed, 03 Sep 2014 10:23:13 GMT

Mille Grazie Angelo