Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

alexbruch86
Contributor

Add a numeral to the value above

Hey,

how can I add to the value above in the same column an other value. It must be calculated in the layout.

So it have to look like this:

the value I will add is here as example 10

amount
0
10
20
30
40
50
60

I think it sounds very simply, but until now I haven't found a solution.

Thanks for any help!

Regards,

Alex

1 Solution

Accepted Solutions
sushil353
Honored Contributor II

Re: Add a numeral to the value above

Please find the attached image..

HTH

Sushiluntitled.JPG

9 Replies
kumarnatarajan
Valued Contributor

Re: Add a numeral to the value above

Hi,

Try this one:

EX: Value + above(Value)

alexbruch86
Contributor

Re: Add a numeral to the value above

Hey,

no this doesn't work. 

This expression show me in the first line - and in the next everytime 20.

Regards,

Alex

sushil353
Honored Contributor II

Re: Add a numeral to the value above

your statement is little bit confusing...

if you want to add numeral 10 to each row of expression then : amount+10.

if you want to add the below or above value to the current row then use above() and below() functions.

HTH

Sushil

leomathew
New Contributor III

Re: Add a numeral to the value above

Hi,

you can try it on the scripting side using previous function.

Value + previous(Value)

Leo

alexbruch86
Contributor

Re: Add a numeral to the value above

Hi,

but when I use above() I only add two values out of another line....but I would add a number to the line below in the same column.

sushil353
Honored Contributor II

Re: Add a numeral to the value above

please post the sample table and the desired output.

sushil353
Honored Contributor II

Re: Add a numeral to the value above

Please find the attached image..

HTH

Sushiluntitled.JPG

alexbruch86
Contributor

Re: Add a numeral to the value above

Hi,

here you have the output I will have. But this is made in the script, and I need it in the layout (in the table).

regards,

Alex

alexbruch86
Contributor

Re: Add a numeral to the value above

Hi,

I got it!!!

Thanks very much!!

regards,

Alex

Community Browser