topic Show dimension row in a text object in QlikView

Show dimension row in a text object

Tue, 31 Mar 2015 11:37:52 GMT

Hi,

i'm quite new on QV. Is there any possibility to show a dimension row in a text object?

eg. last row.

have tried something like: =text(only({1<f_timestamp = {'$(=Max(f_timestamp))'}>} facebook_message))

...but this doesn't work.

I would like to have my outcome like following

Date: 07/03/2015

Text: Some text from the last row

(I don't want them to be side by side as in a straight table)

hope someone understand what i am trying to accomplish

Thankful for any help!

/Pierre

swuehl — Fri, 17 Jul 2015 22:07:05 GMT

=text(only({1<f_timestamp = {'$(=Max(f_timestamp))'}>} facebook_message))

This could work, you probably just need to format the max(f_timestamp) according to your field format, something like this using your format code

=text(only({1<f_timestamp = {'$(=Timestamp(Max(f_timestamp),'YYYY-MM-DD hh:mm:ss'))'}>} facebook_message))

or maybe even easier, try

=FirstSortedValue( facebook_message, -f_timestamp)