Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a need to retrieve the value from a specified row of a column in a chart and use it in every row.
As an example:
Date | Qty | Average | Special | =fabs(Average*(RowNo()=3)) |
---|---|---|---|---|
01/05/2015 | 10 | 10 | 140 | 0 |
02/05/2015 | 20 | 15 | 210 | 0 |
03/05/2015 | 12 | 14 | 196 | 196 |
04/05/2015 | 9 | 12.75 | 178.5 | 0 |
05/05/2015 | 18 | 13.8 | 193.2 | 0 |
06/05/2015 | 21 | 15 | 210 | 0 |
So, the special column multiplies the figure from the average column with the value in the 3rd row of the average column. If I create an expression =fabs(Average*(RowNo()=3)) I get the number I want but only on the 3rd row. How do I write the expression to get the values as shown in the Special column?
You can use:
Top(TOTAL [Average], 3 )
Excellent, thanks @Petter_Skjolden. Such a quick answer too.
That's exactly what I like about QlikView - being able to discover new useful techniques after years of using it
I second that.
Although I am still a new to QlikView, but I have learnt a whole lot by just being active on the community. I learn less by answering to the things I know, but more from looking at other peoples responses which gives me new ideas.