Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to get a value in the first row?

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:

200720082009
a10720
b20515
c30230
d40125

and the expected result is

200720082009
a10720
b10720
c10720
d10720

Any help is very appreciated.

Thanks!

LEandro

Tags (3)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: How to get a value in the first row?

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

View solution in original post

3 Replies
Highlighted
Specialist
Specialist

Re: How to get a value in the first row?

mira el ejemplo.. creo que hablas español

saludos

Highlighted
MVP
MVP

Re: How to get a value in the first row?

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

View solution in original post

Highlighted
Not applicable

Re: How to get a value in the first row?

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