Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
aitmessaoudali
Contributor

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

Re: replace a field bast on the min date

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.
3 Replies

Re: replace a field bast on the min date

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.
aitmessaoudali
Contributor

Re: replace a field bast on the min date

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

Re: replace a field bast on the min date

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.