Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nagarjuna123
New Contributor II

How to replace dimension data

Hi ,

One of my field data is like below

Month

Jan

Feb

Mar

sep

aug

I am excepting o/p is like this in Dimension level(UI Level only need)

Month

January

February

March

August

Thanks,

8 Replies
Chanty4u
Esteemed Contributor III

Re: How to replace dimension data

try this

date(fieldname,'MMMM')

Chanty4u
Esteemed Contributor III

Re: How to replace dimension data

or may be

=Dual(Month(field),date(field,'MMMM'))

nagarjuna123
New Contributor II

Re: How to replace dimension data

Not for montht field Dimension is like below....

type code is dimension

red

raj

nag

babu

o/p

reddy

raju

nagaraju

babureddy

Chanty4u
Esteemed Contributor III

Re: How to replace dimension data

you have limited values or more values you have?

wassim1988
New Contributor III

Re: How to replace dimension data

You should use the function "month(Month)" and set the variable in the beginning of the script before the load like this :

SET MonthNames='January;February;March;August';

mato32188
Contributor III

Re: How to replace dimension data

Hi,

add as dimension:

Pick( Match(Month,'Jan','Feb','Mar','Apr','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),

'January','February','March','April','June','July','August','September','October','November','December' )

BR

Martin

Re: How to replace dimension data

Question not clear, You could create one more field with full names and use the same where you want?

Life is so rich, and we need to respect to the life !!!

Re: How to replace dimension data

Pick() function is the right way but you can try with if also or may be in the script level also.

By Calculated Dimension

=if(Match(Month,'Jan'),'January',

if(Match(Month,'Feb'),'February',

if(Match(Month,'Mar'),'March',

if(Match(Month,'Apr'),'April',

if(Match(Month,'May'),'May'

)))))

Community Browser