Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
philmywallet
Creator
Creator

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

1 Solution

Accepted Solutions
alexandros17
Partner
Partner

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

View solution in original post

3 Replies
alexandros17
Partner
Partner

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

View solution in original post

sunny_talwar

Try this:

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

philmywallet
Creator
Creator
Author

Perfect, Thanks