Qlik sense - Only show latest date in table

[varmekontrol]

Hi

I am pretty sure this was already answered several times. I know it´s out there, I have read plenty of examples, but I can´t seem to implement the suggestions on my table.

I have a table like the one below.

Import date	no	serial	action
2016-01-05	734394	433126681	TRS - aldrig hørt
2016-01-08	734394	433126681	TRS - aldrig hørt
2016-01-12	734394	433126681	TRS - aldrig hørt
2016-08-30	734394	433126681	TRS - ikke hørt I 16 dage

I only want the latest "import date" = 2016-08-30 to be visible in my table.

So I only have this in my table.

2016-08-30

734394

433126681

TRS - ikke hørt i 16 dage

[arvind1494]

do u need this in scripting or at front end

[varmekontrol]

Front-end.

Or it can be done in scripting, the only problem (at my end) is that the import_date is pulled with.

date(floor(timestamp#(subfield(filebasename(), '_', 2), 'YYYYMMDD')), 'YYYY-MM-DD') as import_date

So not sure how to wrap it in

[varmekontrol]

Does no one have a solution to my problem?

[priyalvp24]

Hi,

Try This as date dimension

=$(=max(Import date))

[Neymar_Jr]

Hi,

Try using - Date(aggr(MAX([Import date no]),serial))

Thanks,

RT

[balabhaskarqlik]

Do you want to see only the Max date or Do you want to see the Entire Max Date record.

May be, Try this:

For KPI object, to show only max date.

=Max(ExpiryDate)

In table object:

Use: Import Date,no,Serial as Dimensions.

Expression - Considers max date , shows maxdate action value.

=Only({<[Import Date]={"$(=Date(Max([Import Date]),'YYYY-MM-DD'))"}>}  Action)