Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello, I need an expression that calculates the value of always using the previous line, is an example in excel, need to do the same in QlikView.
thank you.
look in help for Peek:
Peek('Sales')
Hello
Try this:
percentage adjustment * (1 + peek ('Title of the column'))
'Title of the column shall be the title of the red one in your example.
Rgds
Hi
Try this
RowNo()*(1+FieldNameB))
if you are doing it in the front end, ie a pivot table report use the Above() function
hello, I need to do in the expression could not do using the above help me please
Try this one, it works for me:
LOAD [months years],
[percentage adjustment],
sale,
if([percentage adjustment]='',1+peek(Column)) as KEY,
Column
FROM
[Example (1).xls]
If you want this as an expression in a straight table you'll have to use above()
If you use a pivot table you'll have to use above() or before() depending on how you arrange the fields.
Assuming you want to use a straight table
Add [months years] as the dimension then add the following expresssions.
(Ensure [months years] is sorted correctly)
sale
sum(sale)
adj
sum([percentage adjustment])
calc
if(RowNo()=1,1
,Above(calc) * (adj + 1)
)
sale2
calc * sale
Mark
Thank you, that was exactly what I need.
Please can you mark the right answer as "Correct Answer"? I need the points for my ego
Mark