topic Re: Get Max Dates Row in QlikView

Get Max Dates Row

qlikwiz123 — Wed, 24 Nov 2021 16:55:37 GMT

My data has 6 columns

Data1, Data2, Data3, Data4, Start Date, End Date

I want to create an output with only Maximum Dates per Data1 value as below

MarcoWedel — Wed, 24 Nov 2021 21:35:31 GMT

maybe just a straight table with Data1 as dimension and two expressions Max(StartDate) and Max(EndDate) ?

Vegar — Thu, 25 Nov 2021 05:54:22 GMT

As @MarcoWedel wrote, it is easy to achieve in front end using max(...Date).

I noticed tat you have taggad your question with "Scripting". If you want to achieve this in the load script then ut would look like this.

Load Data1,

Max(StartDate) as StartDate ,

Max(EndDate) as EndDate

Resident [Your Data]

Group By [Data1];