Filter order with last timestamp

[wernickt]

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 AuftragHow is that possible? Thanks in advance!

[rubenmarin]

Hi, you can select wich columns you want to show in your dashboard, timestamp doesn't needs to be included.

To filter max value in this field you can use set analysis:
Only({<dateField={$(=date(max(dateField)))}>} Programmnummer)

This filters data, if it's in a  table it should be in all the expressions of the table, or in a calculated dimension.