topic Re: Qlik Sense Issue Fixing (Table) in App Development

Qlik Sense Issue Fixing (Table)

kwoklimho — Thu, 29 Aug 2019 03:04:43 GMT

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 — Thu, 29 Aug 2019 03:31:58 GMT

Try this:

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

kwoklimho — Thu, 29 Aug 2019 03:46:17 GMT

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 — Thu, 29 Aug 2019 03:48:30 GMT

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

kwoklimho — Thu, 29 Aug 2019 03:54:38 GMT

Just like this way to show the content.

Gysbert_Wassenaar — Thu, 29 Aug 2019 07:04:38 GMT

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 — Thu, 29 Aug 2019 07:25:58 GMT

Can i get your raw data?

sugathirajkumar — Thu, 29 Aug 2019 09:44:57 GMT

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 — Thu, 29 Aug 2019 09:49:05 GMT