Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Defining field from Access database as text

One of my QlikView applications pulls data from an Access Database.  Access has a field as a text field, but when the data goes to QlikView it seems to convert some of the codes to numbers while leaving the ones beginning with a letter as text.  What can I do so that QlikView considers all entries for this field as text?  I tried modifying my load statement the way I’d do it if this was an Excel file.

Text(Header_Diagnosis_Code_Primary) as [Primary Diagnosis Code]

However, QlikView didn’t recognize the Text command as part of this load statement like it did in the load statements for my Excel files.

Any help will be appreciated!