topic Re: How to write a script to show the date format in QlikView

How to write a script to show the date format

Mon, 21 Dec 2015 01:18:55 GMT

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

oknotsen — Mon, 21 Dec 2015 04:57:22 GMT

Change

Date($(Max Date Selected))

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

tamilarasu — Mon, 21 Dec 2015 05:08:33 GMT

Also try,

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

robert_mika — Mon, 21 Dec 2015 05:25:05 GMT

Or if this is permanent change.

Go to your variable and change the format there.

Feeling Qlikngry?

Anonymous — Mon, 21 Dec 2015 06:09:57 GMT

Hi,

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

ahbzshk07 — Mon, 21 Dec 2015 06:27:48 GMT

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

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

will be better option...

oknotsen — Mon, 21 Dec 2015 07:14:00 GMT

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 .