Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rendiyan
Partner - Creator
Partner - Creator

[ASK] set analysis for latest location of a person based on period

Dear QlikView master,

i have to count total person in each location based on person's latest location period (date_end).

And every person have it's own period in each location.

i create a straight table without set analysis, it shows like below :

LocationDate_EndPersoncount(Person)
A28/02/2012111
B28/05/2015111
C25/01/2014221
D25/05/2015221
E25/04/2016221
F27/04/2016331

And expected result shows like below :

LocationDate_EndPersoncount(Person)
B28/05/2015111
E25/04/2016221
F27/04/2016331

How to create like result shows above?

Thanks,

Best Regards

1 Solution

Accepted Solutions
sunny_talwar

Try firstSortedValue() function

Capture.PNG

Dimension

Person

Expressions

=FirstSortedValue(Location, -Date_End)

=Date(Max(Date_End))

=FirstSortedValue([count(Person)], -Date_End)

View solution in original post

2 Replies
sunny_talwar

Try firstSortedValue() function

Capture.PNG

Dimension

Person

Expressions

=FirstSortedValue(Location, -Date_End)

=Date(Max(Date_End))

=FirstSortedValue([count(Person)], -Date_End)

rendiyan
Partner - Creator
Partner - Creator
Author

thx Sunny,

it solve one of my issue related to this condition