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

[MK_QSL]

use below in script...

Date((YourDateField,'MMM-YY') as YourDateField

[#3]

Hi Manish,

Thanks fr quick Response but its not working.

[#4]

Any other solutions QlikDevs? ?

[MK_QSL]

Provide sample file or apps.. Rather than guessing your field format, we can have a close look...

[trdandamudi]

Pratik,

Try the below code in the script and you will get the desired result:

Date#(Date(Your_Date_Field, 'MMM-YY')) as New_Date

[#7]

Hi this shows no data to display in the chart.

Thanks

[PrashantSangle]

Hi,

Please post demo app.

Regards

[senpradip007]

Try this....

Date(Date#(YourDateField,'DD-MM-YYYY'),'MMM-YY') as YourDateField

[#10]

Attaching the snapshots. manishkachhia

1st showing source

2nd chart is the output when i use expression as PlannedMonth and ExpectedMonth as is.

3rd chart is the output when i use the expression as Month(PlannedMonth) and Month(ExpectedMonth).

4th chart is the output when i use the expression as MonthName(PlannedMonth) and MonthName(ExpectedMonth).