topic Re: Format Dimension - Script in QlikView

Format Dimension - Script

Thu, 10 Dec 2015 08:05:39 GMT

Morning

How to format a date from 12.15.2015 to monthyear 12.2015 and a number 12,44567778 to decimal number 12,45 while loading for using later as dimension?

LOAD

monthyear

decimalnumber

Or how to format dimension?

Is it possible - I searched for solutions but didnt found.

Thank you.

Re: Format Dimension - Script

jonathandienst — Thu, 10 Dec 2015 11:33:32 GMT

LOAD

Date(Date#(monthyear, 'MM.DD.YYYY'), 'MM.YYYY') As Date,

Num(decimalnumber, '0,00', ',') As Number,

...

Re: Format Dimension - Script

maxgro — Thu, 10 Dec 2015 11:35:47 GMT

Date(MonthStart(date#('12.15.2015', 'MM.DD.YYYY')), 'MM.YYYY')

or without MonthStart

round(number, 0.01)

Re: Format Dimension - Script

sunny_talwar — Thu, 10 Dec 2015 11:37:11 GMT

For date you can use date function and for number use Num() function

Date(DateField, 'MM.YYYY') as DateField,

Num(NumberField, '##.00') as NumberField

Re: Format Dimension - Script

Thu, 10 Dec 2015 11:50:46 GMT

Thank you - I am happy now.