Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

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.
Creator
Creator

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

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