Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How do you change the format of the Dimensions in a chart?

I know that I can change the format of the expression but I'm not sure how to change the format of the dimension. It is in a date format. At the moment it is like 01/01/01 but I would like to change it so that it looks like Mon 1.

Thanks

Tags (3)
1 Solution

Accepted Solutions

Re: How do you change the format of the Dimensions in a chart?

HI

Try like this

=Weekday(date#('01/01/2012','DD/MM/YYYY'))& ' '&day(date#('01/01/2012','DD/MM/YYYY'))

or

=Weekday(DateField) &' '&Day(DateField)

if date format is in correct format..

Hope it helps

or

load in sxcript like that .ex:

Load *, weekday(Datefield)&''&Day(Datefield) as WeekDayField from tablename;

Then use that in chart as dimension

3 Replies
christian77
Valued Contributor

Re: How do you change the format of the Dimensions in a chart?

Hi:

Formatted dimension:

Num(YourDate,’YourFormat’) -------????will work???

Or

Aggr(Num(YourDate,’YourFormat’), YourDate)

Or

Aggr(weekday (YourDate) &',' & day(YourDate), YourDate) 

Re: How do you change the format of the Dimensions in a chart?

HI

Try like this

=Weekday(date#('01/01/2012','DD/MM/YYYY'))& ' '&day(date#('01/01/2012','DD/MM/YYYY'))

or

=Weekday(DateField) &' '&Day(DateField)

if date format is in correct format..

Hope it helps

or

load in sxcript like that .ex:

Load *, weekday(Datefield)&''&Day(Datefield) as WeekDayField from tablename;

Then use that in chart as dimension

Not applicable

Re: How do you change the format of the Dimensions in a chart?

The =Weekday(DateField) &' '&Day(DateField) worked thanks for your help.

Community Browser