Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to apply firstsorted function for below case.

Dear All,

I have one requirement to find unique value.so please help me and check how we can do on script level.


INPUT:-

Input.PNG

Output:-

output.PNG

1 Reply

May be like this

LOAD Company,

          Date(Max(Date)) as Date,

          FirstValue([Sales Person]) as [Sales Person]

FROM ....

Group By Company