Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
kevincase
Creator II
Creator II

How to filter out rows on straight table?

I have data that has Id, Condition, Status as Dimensions with Date and Time as Dimensions.  I need to display only the latest entry.  This needs to be done in the front end, not in script.

For example,

Straight Table:

Start.png

Desired results:

End.png

Any ideas?  Thanks!

2 Replies
idogridish2
Creator III
Creator III

Hi,
create a new dimension in the script Date+Time as DateTime,

then in the table' insted of Date field create a calculated dimension:

=Aggr(Only({$<DateTime={"=Aggr(rank(DateTime,4),ID,date,time)=1"}>}date),ID,date,time)

then uncheck "Include Null Values"

2019-05-25_0036.png

i am attaching an example.

BR

kevincase
Creator II
Creator II
Author

BR,

Thanks for the quick response.  Unfortunately, I can not modify the model/script to include a new dimension.  Business dictates that the date and time need to be separate dimensions.  This is why I was looking to do this in the 'front end' only so performing set analysis is not possible.

Thanks for the effort!

Kevin.....