topic Re: Display one active record in QlikView

Display one active record

Tue, 06 Jan 2015 07:53:32 GMT

Hi All,

I need to know if there is an option to display one record from a list of active rows/fields in expression similar to script (where RowNo()<1) which gives one record from the uploaded data.

Thanks,

Sai.

Re: Display one active record

jagan — Tue, 06 Jan 2015 08:11:31 GMT

Hi,

In script you need to derive a new column like below

LOAD

RecNo() AS RecordNumber,

FROM DataSource;

Now in Straight table just give dimensions you require and give below expression

=Only({<RecordNumber={'$(=Min(RecordNumber))'}>} RecordNumber)

Hope this helps you.

Regards,

Jagan.

Re: Display one active record

anbu1984 — Tue, 06 Jan 2015 08:14:26 GMT

Expr: If(RowNo() = 1,Field)

If you want to display latest row within a group based on date, then you can use Firstsortedvalue()

Expr: Firstsortedvalue(Field,-date)

If this is not helping you, can you provide sample input and expected output