Discussion Board for collaboration on QlikView Layout & Visualizations.
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
I think it sounds very simply, but until now I haven't found a solution.
Thanks for any help!
Go to Solution.
Please find the attached image..
Try this one:
EX: Value + above(Value)
no this doesn't work.
This expression show me in the first line - and in the next everytime 20.
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.
you can try it on the scripting side using previous function.
Value + previous(Value)
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.
please post the sample table and the desired output.
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).
I got it!!!
Thanks very much!!