Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
m_woolf
Master II
Master II

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

How do you have that column formatted in QlikView?

Not applicable
Author

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

The column is formatted as number in QlikView.

m_woolf
Master II
Master II

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

Not applicable
Author

It is a number with no decilmal places.

m_woolf
Master II
Master II

Can you post your qvw?