Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

changing format of the data?

Hi ,

i have bar chart  and i am showing data in date wise

like

dim is date

date:

1/1/2014

1/2/2014

and expr is sum(sales)

now i am getting chart date wise  i have  like   1/1/2014   1/2/2014   in x-axis

but  my req is i want change it in x-axis like     1/jan/2014 ,2/feb/2014  ?

how to do this ?

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

Date(Date#('1/1/2014','DD/MM/YYYY'),'DD/MMM/YYYY')

View solution in original post

3 Replies
anbu1984
Master III
Master III

Date(Date#('1/1/2014','DD/MM/YYYY'),'DD/MMM/YYYY')

MarcoWedel

if date field is already dual, then simply

Date(date, 'D/MMM/YYYY')


will do as a calculated dimension.


Else you could change the number format in the chart properties.

its_anandrjs

Hi,

Add another calculated field in the load script or you can use calculated dimension in chart also

Load

Date(date,'DD/MMM/YYYY') as NewDatefield

From Source;


Or if not in date format

Load

Date(Date#(date,'D/M/YYYY'),'DD/MMM/YYYY') as NewDatefield

From Source;


Regards
Anand