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: 
vishus913
Partner - Creator
Partner - Creator

How to show the values corresponding to the maximum period of a group

Hi All,

I have a table in my data model which is as below:

Worker     Period                 Plan

A                 nov 2018           10

A                oct 2018             15

B                nov 2018           11

C                 Aug 2018           12

C                Sept 2018             15

 

Now I want to show my output as

A                     Nov 2018              10

B                   nov 2018                 11

C                 Sept 2018                15

 

I want to this at UI only using set analysis or some other logic.

Kindly help to how to do so

 

Regards,

Vikas

Labels (1)
4 Replies
pathiqvd
Creator III
Creator III

Hi ,

    Try This,

Sum({<Period={"=aggr(max(Period),Worker)"}>}Plan)

 

Regards,

vishus913
Partner - Creator
Partner - Creator
Author

Hi,

 

It didn't work

vishus913
Partner - Creator
Partner - Creator
Author

@Sunny talwar,

Any help over this please?

sunny_talwar

May be using FirstSortedValue() function

FirstSortedValue(Plan, -Period)