topic Change format to dimension in QlikView

Change format to dimension

Wed, 11 Jun 2014 14:46:25 GMT

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

Re: Change format to dimension

Gysbert_Wassenaar — Wed, 11 Jun 2014 14:48:44 GMT

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).

Re: Change format to dimension

jonathandienst — Wed, 11 Jun 2014 14:49:13 GMT

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

Re: Change format to dimension

Nicole-Smith — Wed, 11 Jun 2014 14:49:54 GMT

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')

Re: Change format to dimension

Wed, 11 Jun 2014 15:09:57 GMT

thanks a lot!!!

Re: Change format to dimension

Wed, 11 Jun 2014 15:10:02 GMT

thanks a lot!!!

Re: Change format to dimension

Wed, 11 Jun 2014 15:10:10 GMT

thanks a lot!!!