Date field in excel is coming with quotation symbol ie Apr'11

[#1]

Hi,

In Excel Date field is Coming with Quotation, Please let me know to extract year like 2011-12 and quarter.

If i change in excel Apr'11 to apr-11 it becomes apr-12 in qlikview.

Regards,

Madhukumara

[sivarajs]

dont change into excel

do it in qlikview

use replace(fieldname,''','-')     // eg; replace('Apr'11,''','-')  Apr-11

[#3]

Not Working because quotation ' its taking into consideration

[sivarajs]

how the Apr'11 your calculating

is there in a field

how did you check?

[#5]

From data itself its coming like tat.

In qlikview i tryied.

[nilesh_gangurde]

Hi madhu,

Attache the sample data with the .qvw file

Regards,

Nilesh Gangurde