Qlik Sense Issue Fixing (Table)

[kwoklimho]

Hi All,

As the attached image, the date should show 2/5/2019 on the second column.

How can I apply the logic to change the data position?

Regards,

Leo

[Arthur_Fong]

Try this:

AGGR(MAX(IF(FakeDate<=Date,FakeDate)),UserID,CostCenter).

[kwoklimho]

I have tried the formula. However, it is not correct.

What I want is the second date should be null, only showing the first record and the third record.

[Arthur_Fong]

Do you mean you want to sort the null value as the last record?

[kwoklimho]

UserID	Formula for Date	CostCenter
1	2/5/2019	B
1	-	A
2	1/4/2019	C

Just like this way to show the content.

[Gysbert_Wassenaar]

Add the word NODISTINCT into the Aggr function: Aggr(NODISTINCT Max(...etc

Try this one as well: MAX(TOTAL <UserID> IF(FakeDate<=Date,FakeDate))

[sugathirajkumar]

Can i get your raw data?

[sugathirajkumar · Accepted solution]

DATE(MAX(AGGR(DATE(MAX(FakeDate),'D/M/YYYY'), UserID)),'D/M/YYYY')

load * inline [
UserID,FakeDate, CostCenter
1, 2/5/2019, B
1, 1/4/2019, A
2, 1/4/2019, C

];

[sugathirajkumar]