topic How to use max(Date) in a chart in QlikView

How to use max(Date) in a chart

tappij2012 — Mon, 29 Jan 2018 10:43:46 GMT

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.

Re: How to use max(Date) in a chart

jonathandienst — Mon, 29 Jan 2018 10:48:35 GMT

Something like

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

Re: How to use max(Date) in a chart

tappij2012 — Mon, 29 Jan 2018 11:04:25 GMT

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?

Re: How to use max(Date) in a chart

arvind1494 — Mon, 29 Jan 2018 11:28:03 GMT

in a set expression

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

Re: How to use max(Date) in a chart

tappij2012 — Mon, 29 Jan 2018 12:16:34 GMT

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)

Re: How to use max(Date) in a chart

sunny_talwar — Mon, 29 Jan 2018 13:02:27 GMT

May be this

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

Re: How to use max(Date) in a chart

jonathandienst — Tue, 30 Jan 2018 05:10:57 GMT

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)