Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

replace a field bast on the min date

Hello community,

i want to to create dimension d in the screenshot, keeping only the id of the min(date) but also keeping all the lines and replacing the other ids by the id of the min date.

thanks in advance

1 Solution

Accepted Solutions
Highlighted

Final:
Load A,
date,
c
From Table;
Left Join
Load A,
firstsortedvalue(c,date) as d
Resident Final
group by A;
Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

3 Replies
Highlighted

where you want?? in front end or in script??
In front end you can try with firstsortedValue(value,-date)

Regards,
Prashant Sangle
Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Creator
Creator

hello, i would prefer to implement it in the script. thanks

Highlighted

Final:
Load A,
date,
c
From Table;
Left Join
Load A,
firstsortedvalue(c,date) as d
Resident Final
group by A;
Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post