topic Load field having the most recent date in qlik in App Development

Load field having the most recent date in qlik

Aspiring_Developer — Thu, 27 Aug 2020 20:45:47 GMT

Hello everyone.

Please help me as I am new to qlik.

Below is the data

Milestone Date

M1. 202001

M1 ,201901

M2, 202003

M2, 202006

Desired output

M1 202001

M2 202006

Want to capture milestone for the latest date

Please help

@reddy-s @kumar1 @Kushal_Chawda

Re: Load field having the most recent date in qlik

Kushal_Chawda — Thu, 27 Aug 2020 21:04:22 GMT

//Script logic

Data: load Milestone, date(max(floor(date#(Date,'YYYYMM'))),'YYYYMM') as Date FROM Source group by Milestone;

// Front end solution

Create a table object with Dimension Milestone and below expression

Date(max(Date),'YYYYMM')

Re: Load field having the most recent date in qlik

Aspiring_Developer — Fri, 28 Aug 2020 05:24:55 GMT

@Kushal_Chawda

I tried the approach , but it giving me the data like this :

From backend itself , i should only get the latest values for Milestone ie.

if i take this single field in table it should populate values only for latest dates.

M1, M2,M3 having values for latest date

Re: Load field having the most recent date in qlik

SerhanKaraer — Fri, 28 Aug 2020 07:58:09 GMT

Hello Aspiring_Creator,

As @Kushal_Chawda suggested, getting max for each milestone should generate the output you need.

Likewise, you can use sorting function and get the same result.

LOAD MileStone, FirstSortedValue(Date,-Date) as Date GROUP BY MileStone;
LOAD * INLINE [
MileStone, Date
M1, 202001
M1, 201901
M2, 202003
M2, 202006
];

Regards,

Re: Load field having the most recent date in qlik

Kushal_Chawda — Fri, 28 Aug 2020 09:16:03 GMT

try below

Data: load Milestone, date(date#(Date,'YYYYMM'),'YYYYMM') as Date FROM Source; inner join(Data) load date(max(Date),'YYYYMM') as Date resident Data;