topic Re: Expression .... Show me the date in QlikView

Expression .... Show me the date

Anonymous — Wed, 02 Mar 2016 14:41:01 GMT

I have an expression that I am putting in a text box, but it shows the number not the date. The expression is :

=min(aggr(if(fabs(Publish_Date-date(vToday)) = vMinDate,Publish_Date), Publish_Date))

It currently outputs

The next publish date is : 42430.

How do I get it to show

The next publish date is : 01/03/2016

I have attached the example.

Many thanks

Phil

alexandros17 — Wed, 02 Mar 2016 14:43:25 GMT

use this expression

='Next Publish Date '&Date(min(aggr(if(fabs(Publish_Date-date(vToday)) = vMinDate,Publish_Date), Publish_Date)),'DD/MM/YYYY')

let me know

sunny_talwar — Wed, 02 Mar 2016 14:43:34 GMT

Try this:

='Next Publish Date '& Date(min(aggr(if(fabs(Publish_Date-date(vToday)) = vMinDate,Publish_Date), Publish_Date)), 'DD/MM/YYYY')

Anonymous — Wed, 02 Mar 2016 14:44:36 GMT

Perfect, Thanks