Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Change format to dimension

Hi,

I have in my dashboard, a straight table with several dimension which are dates in format "DD-MM-YYYY".

I need to show these dates in format "MMM-YY".

How I can do that?

Best Regards

Tags (2)
1 Solution

Accepted Solutions

Re: Change format to dimension

Use the date() function to show the dates in the format you need. date(MyDate, 'MMM-YY'). You can do this in the script or in an expression (or a calculated dimension if you want to format a date dimension).


talk is cheap, supply exceeds demand
6 Replies

Re: Change format to dimension

Use the date() function to show the dates in the format you need. date(MyDate, 'MMM-YY'). You can do this in the script or in an expression (or a calculated dimension if you want to format a date dimension).


talk is cheap, supply exceeds demand
MVP
MVP

Re: Change format to dimension

Hi

In the Document Properties | Number tab, select Date and enter MMM-YY as the format or else use a Date(..., 'MMM-YY') to format the field on loading. This will avoid the need to create a calculated dimension.


HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Re: Change format to dimension

Does QV already know it's a date?  If it does, you can simply do:

date(YourField, 'MMM-YY')

However, if QV isn't recognizing the field as a date, you must do:

date(date#(YourField,'DD-MM-YYYY'),'MMM-YY')

If you're using a bar chart, or the like, (where you want to see only a single bar for a month), you need to use the monthstart() function around either of the two expressions above in order to only show one (if not, it will show a different bar for each day of the month that you have data):

date(monthstart(YourField), 'MMM-YY')

date(date#(monthstart(YourField),'DD-MM-YYYY'),'MMM-YY')

Not applicable

Re: Change format to dimension

thanks a lot!!!

Not applicable

Re: Change format to dimension

thanks a lot!!!

Not applicable

Re: Change format to dimension

thanks a lot!!!

Community Browser