Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Issue with export to excel

Hi,

I recently upgraded to QliView 9. One of the issues that I have noticed is that when I export a table to excel, it does not display the values for some columns in excel after export. If I format that column in excel and click on 'Number' then the values show up.

I have attached the excel export and shaded the column in question in yellow.

Does anyone have an idea?

5 Replies
mwoolf
Honored Contributor II

Issue with export to excel

The export formatted that column as a Custom format in Excel.

How do you have that column formatted in QlikView?

Not applicable

Issue with export to excel

A small correction. I am talking about QlkView 10 here.

The column is formatted as number in QlikView.

mwoolf
Honored Contributor II

Issue with export to excel

Can you be more specific? There are many kinds of number formats.

Not applicable

Issue with export to excel

It is a number with no decilmal places.

mwoolf
Honored Contributor II

Issue with export to excel

Can you post your qvw?

Community Browser