topic Re: Need to add max date in expression in QlikView

Need to add max date in expression

Mon, 10 Nov 2014 22:02:11 GMT

Hi,

I am trying to write an expression for a chart that will show the total number of work orders for a specific department. I also need to provide this by the max OPEN_DATE. Basically I need to show the most recent data.

I’ve got this so far:

sum({<[Department]={'Development Services'}, [Work Order Status]={'Pending','Overdue'}>} COUNT_TICKETS)

But I’m unclear on how to incorporate the max OPEN_DATE in to my expression.

Any help or guidance would be greatly appreciated.

Re: Need to add max date in expression

its_anandrjs — Tue, 11 Nov 2014 05:58:29 GMT

Try and write like

sum({<[Department]={'Development Services'}, [Work Order Status]={'Pending','Overdue'},

OPEN_DATE = {'$(=Max( OPEN_DATE ))'} >}COUNT_TICKETS)

Regards

Anand

Re: Need to add max date in expression

anbu1984 — Tue, 11 Nov 2014 06:06:10 GMT

Use Date format of OPEN_DATE in this expression

sum({<[Department]={'Development Services'}, [Work Order Status]={'Pending','Overdue'}, OPEN_DATE = {'$(=Date(Max( OPEN_DATE )),'MM/DD/YYYY')'}>} COUNT_TICKETS)

Re: Need to add max date in expression

ashfaq_haseeb — Tue, 11 Nov 2014 06:10:31 GMT

Hi,

add this to your code.

OPEN_DATE = {"$(=Max( OPEN_DATE ))"}

Try like this

sum({<[Department]={'Development Services'}, [Work Order Status]={'Pending','Overdue'},

OPEN_DATE = {"$(=Max( OPEN_DATE ))"} >}COUNT_TICKETS)

Regards

ASHFAQ

Re: Need to add max date in expression

Wed, 12 Nov 2014 20:23:07 GMT

Thanks you for your response - this worked!