Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Date Format

Hello Everyone,

I have an issue which I know is very easy to solve, there's just something I am not quite getting right.

I have a Filter Pane which filters the dimension date. The date is showing up in the Qlik Sense formate, i.e 42370, 42401 etc.

I would like this date to be displayed in the DD MMMM YYYY format.

I have tried to do so in using the following expression: Date#([Date][, 'DD MMMM YYYY']) (Date is the name of the field containing dates).  However, there's an error in my expression.

Please can someone tell me what I am doing wrong?

Thank you all in advance,

Alison

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Date Format

Did you try this?

Date(Num#(Date), 'DD MMMM YYYY')

12 Replies
antoniotiman
Honored Contributor III

Re: Date Format

Hi Aliso,

try

Date(Date,'DD MMMM YYYY')

Regards,

Antonio

Not applicable

Re: Date Format

Hello Antonio,

Thank you for your response.

I have tried your suggestion. When I enter it, the script has no error but when it is applied there are no longer any values found in the filter pane.

MVP
MVP

Re: Date Format

For formatting, you just need a date function and date#()... date#() is used for interpretation (i.e. when QlikView is having a difficult time understanding that you date field is a date field. So in your case, you already have a date (in the shape of a number), so you need to use Date() function.

Also, the format doesn't have to be surrounded by square brackets

Date([Date], 'DD MMMM YYYY')

MVP
MVP

Re: Date Format

May be try this

Date(Num#(Date), 'DD MMMM YYYY')

Not applicable

Re: Date Format

Hi Sunny,

Thank you.

I am aware of all that. And yet, I am still having difficulty. As I said above in my response to Antonio, after applying that script I am left without any values in the filter pane. Why is that?

Re: Date Format

Hi,

Try this ways

Ex:-

LOAD *, Date(NewNUM , 'DD MMMM YYYY') as NewDate;

LOAD *, Date(NumDate) as NewNUM;

LOAD * Inline

[

NumDate

42370

42401

];

See attached

Regards

Anand

Re: Date Format

Are you using this expression in the dimension be clear you can use this on the dimension

Ex:-


Date ( [Date], 'DD MMMM YYYY' )


Date( YourdateFieldHere, 'DD MMMM YYYY')


Be clear on the field name and date syntax.


Regards

Anand

Not applicable

Re: Date Format

Hello Anand,

Thank you for your response.

That does work, but it seems a little over-complex and it would require quite a lot of time, inputting the dates manually into the data load editor. Is there no solution that less taxing? 

MVP
MVP

Re: Date Format

Did you try this?

Date(Num#(Date), 'DD MMMM YYYY')