Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
wernickt
Contributor
Contributor

Filter order with last timestamp

Hi everyone,

I have a specific problem in Qlik Sense (working with Qlik Sense Enterprise) and hope that u can help me 🙂 I have already read in 3 database tables. One of the tables ‘TeileDaten’ owns the column ‘timestamp’.

On my dashboard I would like to show part of the table ‘TeileDaten’. It includes the 4 columns as in the picture below. I only want to show one row with the data of the last order (last timestamp), but the table on the dashboard should not include the column ‘timestamp’.

Aktueller AuftragAktueller Auftrag

How is that possible? Thanks in advance!

 

 
1 Reply
Vegar
MVP
MVP

If you have any measure in your table then you could fetch the latest timestamp data by adding the following SET to all table measures.
{<[timestamp]={"$(=MAX([timestamp]))"}>}