topic Re: Max Date finding in QlikView

Max Date finding

atlantis_shahri — Tue, 28 Nov 2017 05:36:09 GMT

Hey guys, I need only the maximum dates for each Product in a table.

Like Bread 19/11/2017

Sugar 28/11/2017

Tea 18/11/2017

Tried something like this =Only({<PDate={'$(=max(Date))'}>} PDate) for Serial date 2. Didn't work.

Any kind of help is much appreciated and thanks in advance

Regards

Shahriar.

Re: Max Date finding

shraddha_g — Tue, 28 Nov 2017 05:41:23 GMT

Can you share sample date?

What is the data present in PDate?

Re: Max Date finding

atlantis_shahri — Tue, 28 Nov 2017 05:45:51 GMT

This is the test source data.

Table:

Load * inline

[

Product, PDate

Sugar, 11/11/2016

Bread, 12/11/2016

Sugar, 11/11/2017

Bread, 12/11/2017

Sugar, 12/10/2017

Bread, 12/10/2017

Sugar, 28/11/2017

Bread, 19/11/2017

Tea, 18/11/2017

];

Re: Max Date finding

shraddha_g — Tue, 28 Nov 2017 05:53:30 GMT

Where is Date field from expression?

Only({<PDate={'$(=max(Date))'}>} PDate)

Re: Max Date finding

shraddha_g — Tue, 28 Nov 2017 05:54:25 GMT

Try,

Only({<PDate={"$(=Date(max(PDate),'DD/MM/YYYY'))"}>} PDate)

Re: Max Date finding

VishalWaghole — Tue, 28 Nov 2017 05:54:43 GMT

Try below expression,

Dimensions is your product

Expression =Max(Total <Product> Date)

Thanks,

Vishal

Re: Max Date finding

VishalWaghole — Tue, 28 Nov 2017 05:56:07 GMT

Try below expression,

Dimensions is your product

Expression =Max(Total <Product> PDate)

Thanks,

Vishal

Re: Max Date finding

settu_periasamy — Tue, 28 Nov 2017 06:14:03 GMT

Seems to be 'PDate' is not properly formatted.

Try this.

Table:

LOAD Product,Date(Date#(PDate,'DD/MM/YYYY')) as PDate;

Load * inline
[
Product, PDate
Sugar, 11/11/2016
Bread, 12/11/2016
Sugar, 11/11/2017
Bread, 12/11/2017
Sugar, 12/10/2017
Bread, 12/10/2017
Sugar, 28/11/2017
Bread, 19/11/2017
Tea, 18/11/2017
];

Chart:

Dimension: Production

Expression : Max(PDate)

Re: Max Date finding

atlantis_shahri — Tue, 28 Nov 2017 07:25:58 GMT

This doesn't work.

Re: Max Date finding

atlantis_shahri — Tue, 28 Nov 2017 07:28:27 GMT

This only works when Load Product,Date(Date#(PDate,'DD/MM/YYYY')) as PDate; is added. Thanks.

Re: Max Date finding

atlantis_shahri — Tue, 28 Nov 2017 07:47:41 GMT

I was using complex expressions. Thanks a lot.