topic Qlikview - Set Analysis in If Statement in QlikView

Qlikview - Set Analysis in If Statement

Tue, 12 Jan 2016 14:00:53 GMT

I've in database thow player with same Player_N but with data of creation distinct.

But when I select the Player_N the qlikview return the Player_Name null because it see two different names.

How can I use the following code to obtain only the name of the player which have the last date of Database?

=if(len(Player_N & ' - ' & Player_Name) = 0, '-', Player_N & ' - ' & ({MAX(DATE)} Player_Name))

Thanks!

sunny_talwar — Tue, 12 Jan 2016 17:10:32 GMT

Try something like this:

FirstSortedValue(Player_Name, -DATE)

Tue, 12 Jan 2016 17:34:52 GMT

Thanks Sunny T!

But it still gives me null value

sunny_talwar — Tue, 12 Jan 2016 18:05:02 GMT

Is it possible that you might have multiple names on the max(DATE)?

Try if this works:

FirstSortedValue(DISTINCT Player_Name, -DATE)

Tue, 12 Jan 2016 18:12:04 GMT

It doesn't allow the distinct keyword

I'm thinkg if isn't better use a set analysis expression to search for the Max(Date). What your opinion?

Thanks for helo