Announcements
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
cancel
Showing results for
Did you mean:
Contributor II

## How to use max(Date) in a chart

Hi,

I'll want to use a max(Date) for the charts like below.

Red circle shows all the data, but I want only to see the total of max date. In this case it's 2 instead of 5.

This has to be the same for the Green circle.

6 Replies
Partner - Champion III

Something like

Count({<Date = {"\$(=Max(Date))"}>} customer)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Contributor II
Author

Thanks this works, but I've use an other name then Date, now I'll don't know what to change.

Where do I put the name Datum instead of Date?

Specialist

in a set expression

{<Date={\$(=max(Date))}>}

Contributor II
Author

It doesn't recognize the date format I'll want to use.

How can I put this format (yyyymmdd) in this formule: count({<Date={\$(=max(Date))}>}customer)

MVP

May be this

Count({<Date={"\$(=Date(Max(Date), 'YYYYMMDD'))"}>} customer)

Partner - Champion III
 Robin Tappij Gielen wrote: Thanks this works, but I've use an other name then Date, now I'll don't know what to change. Where do I put the name Datum instead of Date?

Count({<Datum = {"\$(=Max(Datum))"}>} customer)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser