topic Re: How to get latest data in QlikView

How to get latest data

qlikviewwizard — Wed, 13 May 2015 04:23:46 GMT

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

Wed, 13 May 2015 05:30:38 GMT

Try function FirstSortedValue()

qlikviewwizard — Wed, 13 May 2015 07:22:39 GMT

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

PrashantSangle — Wed, 13 May 2015 07:39:52 GMT

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