Discussion board where members can get started with QlikView.
I am very new to Qlik view, I need to show month as the dimensions.
Can some one help me how to convert Month values in my table from 1,2,3....12 to Jan, Feb, Mar....Dec using various options like by if statement, set analysis....
create a mapping table to map month numbers to monthnames during load and then use this field in your charts
Mapping Load * INLINE [
LOAD * ,
Applymap('Map_Month',yourmonthfieldinFACT) as MonthShortName
Another way to do this would be to do like this:
as your dimension
or this in load script
Month(Date#(MonthFieldName, 'M')) as MonthName
and then just use MonthName as your dim
You want to show only one object for this
You may try this too
Take List box and choose Expression from Drop down then paste this and change your field name instead of MonthFieldName then give Title Month
In any Expressions or In Dimensions,
If you write Month(Your date filed),it will brings months name like...jan,feb,,....dec.
if you write num(Month(your date filed)),it will brings months numbers like..1,2,3,...12.
If you want to convert months from numbers(1,2,3........12)to names(jan,feb,.....dec),
Month(Date#(your date filed,'M'))