Value from specified row in chart table

[lawrenceiow]

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?

[petter · Accepted solution]

You can use:

Top(TOTAL [Average], 3 )

[sunny_talwar]

This is awesome Petter‌. Thanks for introducing me to another function in QlikView.

Best,

Sunny

[lawrenceiow]

Excellent, thanks @Petter_Skjolden. Such a quick answer too.

[petter]

That's exactly what I like about QlikView - being able to discover new useful techniques after years of using it

[sunny_talwar]

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.