Discussion board where members can get started with QlikView.
i have bar chart and i am showing data in date wise
dim is date
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 ?
Go to Solution.
if date field is already dual, then simply
will do as a calculated dimension.
Else you could change the number format in the chart properties.
Add another calculated field in the load script or you can use calculated dimension in chart also
Date(date,'DD/MMM/YYYY') as NewDatefield
Or if not in date format
Date(Date#(date,'D/M/YYYY'),'DD/MMM/YYYY') as NewDatefield