Discussion Board for collaboration related to QlikView App Development.
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"
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
Date($(Max Date Selected))
Date($(Max Date Selected), 'MMM-YYYY')
Or if this is permanent change.
Go to your variable and change the format there.
How To /Missing Manual(24 articles)
Just change the expression to Date#($(Max Date Selected),'MMM-YYYY')
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 .