topic Re: return first, second and third rows of a table in QlikView

return first, second and third rows of a table

samuel_brierley — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

ive created a resident table that groups values and sorts them top to bottom and i want to be able to use a first that will return the first, second and third area

Area

Area	Value
a	4
b	3
c	2
d	1

Re: return first, second and third rows of a table

Chanty4u — Thu, 03 Mar 2016 11:17:03 GMT

sort tab sort by ascending by value.

in dimension limit give 5

Re: return first, second and third rows of a table

samuel_brierley — Thu, 03 Mar 2016 11:18:25 GMT

no i would like to use the return the value in a text box

Re: return first, second and third rows of a table

sunny_talwar — Thu, 03 Mar 2016 11:18:35 GMT

May be this:

In a chart

Only({<Value = {"$(='<=' & Max(Value) - 2 & '>=' & Max(Value))"}>} Value)

In a text box

Concat({<Value = {"$(='<=' & Max(Value) - 2 & '>=' & Max(Value))"}>} Value, ', ')

Re: return first, second and third rows of a table

samuel_brierley — Thu, 03 Mar 2016 11:19:11 GMT

Cheers sunny