topic How to get a value in the first row? in QlikView

How to get a value in the first row?

Fri, 05 Oct 2012 13:10:41 GMT

Hi, probably a easy question to good developers.

I need to get the first value of the Pivot table considering the number in the first rown is not always min, max

example below:

and the expected result is

Any help is very appreciated.

Thanks!

LEandro

fdelacal — Fri, 05 Oct 2012 13:57:12 GMT

mira el ejemplo.. creo que hablas español

saludos

swuehl — Fri, 05 Oct 2012 14:03:18 GMT

Try the chart inter record functions, namely top():

=top( only(Value))

with only(Value) being the expression you are using so far (or replace with sum(Sales), .. etc.).

See attached.

Stefan

Fri, 05 Oct 2012 14:11:52 GMT

you are right, easy and simple expression in the end...