Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

5 Replies
sivarajs
Specialist II
Specialist II

dont change into excel

do it in qlikview

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

Not applicable
Author

Not Working because quotation ' its taking into consideration

sivarajs
Specialist II
Specialist II

how the Apr'11 your calculating

is there in a field

how did you check?

Not applicable
Author

From data itself its coming like tat.

In qlikview i tryied.

nilesh_gangurde
Partner - Specialist
Partner - Specialist

Hi madhu,

Attache the sample data with the .qvw file

Regards,

Nilesh Gangurde