topic Re: Show text value for latest date in QlikView

Show text value for latest date

Tue, 15 Jan 2013 14:06:23 GMT

Hello,

I didn't find the answer for my problem on the forum, so I would like to ask for help on that...

I need to display value from maximum (latest) date. I have data as following:

Date	Value
2012/12/31	Medium
2012/11/30	Large
2012/10/31	Small

I would like to display 'Medium' in the text box as this is the value for maximum day in the data I have.

If anyone have the idea how to do it, please help me, cause I'm running out of the ideas on my own .

Re: Show text value for latest date

swuehl — Tue, 15 Jan 2013 14:11:49 GMT

Try FirstSortedValue() function:

=FirstSortedValue(Value, -Date)

as expression in a textbox. Date should have an unambiguous Value for the latest date, and Date field must have a numeric representation.

Hope this helps,

Stefan

Re: Show text value for latest date

Tue, 15 Jan 2013 14:15:29 GMT

Thank you for a very helpful answer .

Now I have a new problem: how to display text value for latest month -1 (according to the table I have attached: 'Large'). Could you please advise... It's more complicated I think.

Re: Show text value for latest date

Tue, 15 Jan 2013 14:18:04 GMT

And now I will answer myself

FirstSortedValue(Value,-Date,2)