Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
as per the format '31/08/2015', using
Date(Date#($(Max Date Selected),'DD/MM/YYYY'),'MMM-YYYY')
will be better option...
Change
Date($(Max Date Selected))
to
Date($(Max Date Selected), 'MMM-YYYY')
Also try,
Date(Date#($(Max Date Selected),'DD/MM/YYYY'),'MMM-YYYY')
Or if this is permanent change.
Go to your variable and change the format there.
Feeling Qlikngry?
Hi,
Just change the expression to Date#($(Max Date Selected),'MMM-YYYY')
as per the format '31/08/2015', using
Date(Date#($(Max Date Selected),'DD/MM/YYYY'),'MMM-YYYY')
will be better option...
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 .