Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
philmywallet
New Contributor III

Expression .... Show me the date

Hi

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

Tags (2)
1 Solution

Accepted Solutions

Re: Expression .... Show me the date

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

3 Replies

Re: Expression .... Show me the date

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

Re: Expression .... Show me the date

Try this:

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

philmywallet
New Contributor III

Re: Expression .... Show me the date

Perfect, Thanks

Community Browser