How to get latest data

[qlikviewwizard]

Hi All,

I want to get the ENAME,SAL,COMM,DEPTNO,GETDATE for each depatarment where latest date of GETDATE.

How to achieve this?

For example

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO LASTDATE GETDATE

84 ENAME84 CLERK 5 20101217 800 500 30 20150316 2015/10/28

[#2]

Try function FirstSortedValue()

[qlikviewwizard]

How to achieve the same? Could you provide in a sample file?

[PrashantSangle · Accepted solution]

Hi,

Find below example from Help Menu

Load Customer,

firstsortedvalue(PurchasedArticle, OrderDate) as
FirstProductBought from abc.csv

group by Customer;

Note:

FirstSortedValue() is aggregated function so you have to use Group by clause and add all the which you dont required to aggregate

Regards