Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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
Highlighted
Champion III
Champion III

Re: How to replace dimension data

try this

date(fieldname,'MMMM')

Highlighted
Champion III
Champion III

Re: How to replace dimension data

or may be

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

Highlighted
Contributor II
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

Highlighted
Champion III
Champion III

Re: How to replace dimension data

you have limited values or more values you have?

Highlighted
Contributor III
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';

Highlighted
Creator III
Creator 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

Highlighted

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

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'

)))))