topic Re: display load time where ID = something in QlikView

display load time where ID = something

Wed, 19 Nov 2014 06:25:57 GMT

Hi I am trying to display time in A TEXT BOX corresponding to latest load. How could I achieve that?

In SQL, query would be something like:

SELECT [TimeDuration]

FROM [TABLE]

WHERE [ID] = (SELECT MAX(ID)

FROM

)

Re: display load time where ID = something

anbu1984 — Wed, 19 Nov 2014 06:28:07 GMT

=Max({<ID={'value'}>}[TimeDuration])

=Max({<ID={'$(=Max(ID))'}>}[TimeDuration])

Re: display load time where ID = something

jonathandienst — Wed, 19 Nov 2014 06:32:29 GMT

In the front end, either of these two:

=Only({<ID={"$(=Max(ID))"}>} TimeDuration)

=FirstSortedValue(TimeDuration, -ID)

HTH

Jonathan

Re: display load time where ID = something

Wed, 19 Nov 2014 06:58:34 GMT

Thanks a lot, anbu's second suggestion worked!

Re: display load time where ID = something

Thu, 20 Nov 2014 06:05:53 GMT

Hi anbu, your suggestion works where the field is numeric, however for some reason it doesn't work where my field is a string. Could you pls help with that?

Re: display load time where ID = something

anbu1984 — Thu, 20 Nov 2014 06:07:57 GMT

Use Max() for numeric fields

Use MaxString() for string fields