Month field format varying in source and Qlikview

[#1]

Hello Everyone,

I have a month field in excel which ive custom formatted to MMM-YY, but when I double click on it in the cell the value displayed is in the format DD-MM-YYYY. When I use this field in Radar(Spider) charts expression the chart display numbers like 1900,1920,1940,1960...

When is use the field like Month(Field) then the values are 0,2,4,6,8.... When is use the field like MonthName(Field) then the values are 10000, 20000, 30000....

I want the chart to display the values As Jan-14,Feb-14.... Jan-15,Feb-15...

Any help would be highly appreciated.

Thanks,

Pratik

[#2]

Same thing no data to display.. it shows..

[#3]

It plots the correct chart wen using Month(PlannedMonth) and Month(ExpectedMonth), but instead of numbers I Want Jan-14, Feb-14 etc..

[#4]

Try like,

=month(date#(PlannedMonth,'MMM-YY'))

=month(date(date#(PlannedMonth,'MMM-YY'),'MMM'))&'-'&year(date(date#(PlannedMonth,'MMM-YY'),'YY'))

[#5]

No data to display.. IDK why its showing weird behaviour

[senpradip007]

Could you please upload sample qvw?

[aveeeeeee7en]

Share the App if possible.

Regards

Av7eN

[#8]

Just for confirmation you are doing this in Excel or in QlikView?

[#9]

Attaching the source and qvw.

Aveeeeeee7en

[#10]

Excel is source and Charts on Qlikview

[#11]

Hi pratik,

       PFA......

1. In Axes tab uncheck 'forced 0'

2. Set the static min and max scale as in the file . min(plannedmonth) , max(plannedmonth)

Regards

Lathaa