Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

How to write a script to show the date format

Hi all,

I am new to use qlikview to build some reports and now have a question about the date formating as follows:

- How to write a script in the Edit Expression box to show the date format like "Aug-2015", instead of "31/08/2015"

Best Regards,

Alan

1 Solution

Accepted Solutions
Highlighted
ahbzshk07
New Contributor III

Re: How to write a script to show the date format

as per the format '31/08/2015', using

Date(Date#($(Max Date Selected),'DD/MM/YYYY'),'MMM-YYYY')

will be better option...

View solution in original post

6 Replies
Highlighted
oknotsen
Honored Contributor III

Re: How to write a script to show the date format

Change

Date($(Max Date Selected))

to

Date($(Max Date Selected), 'MMM-YYYY')

May you live in interesting times!
Highlighted

Re: How to write a script to show the date format

Also try,

Date(Date#($(Max Date Selected),'DD/MM/YYYY'),'MMM-YYYY')

Highlighted

Re: How to write a script to show the date format

Or if this is permanent change.

Go to your variable  and change the format there.

Feeling Qlikngry?

How To /Missing Manual(24 articles)

Highlighted
Partner
Partner

Re: How to write a script to show the date format

Hi,

Just change the expression to Date#($(Max Date Selected),'MMM-YYYY')

Highlighted
ahbzshk07
New Contributor III

Re: How to write a script to show the date format

as per the format '31/08/2015', using

Date(Date#($(Max Date Selected),'DD/MM/YYYY'),'MMM-YYYY')

will be better option...

View solution in original post

Highlighted
oknotsen
Honored Contributor III

Re: How to write a script to show the date format

I noticed you "liked" my reply.

If that means your question is answered, please flag the correct answer as Correct Answer (and optionally flag helpful answers as Helpful).

If not, please let us know what question you still have about this topic .

May you live in interesting times!