topic Re: Help for Loading latest date data in QlikView

Help for Loading latest date data

suryakant241187 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have an data which contains multiple dates but i have to load only latest date data in to the qlikview.

Name	Order date	Price
Surya	11/3/2016	100
Sagar	10/3/2016	100
Siddhesh	9/3/2016	100
Jay	8/3/2016	100
Surya	7/3/2016	100
Sagar	6/3/2016	100

from above data i have to load first row data for surya as it is latest date in qlikview. i have tried MAX function but its not working.

Thanks,

Suryakant

Re: Help for Loading latest date data

Anonymous — Fri, 04 Nov 2016 16:13:23 GMT

...

NoConcatenate

Output:
LOAD
Name,
max("Order Date") as Date,
FirstSortedValue(Price,-"Order Date") as Price
Resident YourTable
Group by Name;

DROP Table YourTable;

But you have to ensure, that there's only one "firstsorted value" per date within the dimension name...

Re: Help for Loading latest date data

trdandamudi — Fri, 04 Nov 2016 17:00:32 GMT

Hope this is what you are looking for:

Source_Data:

LOAD * INLINE [

Name, Orderdate, Price

Surya, 11/3/2016, 100

Sagar, 10/3/2016, 100

Siddhesh, 9/3/2016, 100

Jay, 8/3/2016, 100

Surya, 7/3/2016, 100

Sagar, 6/3/2016, 100

];

NoConcatenate

TMP:

LOAD max(Orderdate) as max_Orderdate

Resident Source_Data;

Let vMax = peek('max_Orderdate',0,'TMP');

Drop table TMP;

NoConcatenate

Final_Data:

Load *

Resident Source_Data

Where Orderdate=$(vMax);

Drop Table Source_Data;

Re: Help for Loading latest date data

Mon, 07 Nov 2016 10:58:10 GMT

Hi,

You can get the date as follows (in the script):

Temp:

Load

//min(date) as minDate,

max(date) as maxDate

Resident TABLE;

Let varMinDate = Num(Peek('minDate', 0, 'Temp'));

Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));

DROP Table Temp;

I hope the answer will be useful!