Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview - Set Analysis in If Statement

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!

4 Replies
sunny_talwar

Try something like this:

FirstSortedValue(Player_Name, -DATE)

Not applicable
Author

Thanks Sunny T!

But it still gives me null value

sunny_talwar

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

Try if this works:

FirstSortedValue(DISTINCT Player_Name, -DATE)

Not applicable
Author

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