Send to Excel format

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

When sending tables to Excel from the webview version of my QV dashboard, the used format in Excel is inconsistent. Sometimes (when filters are applied) the Excel export is exactly similar to the QV table, which is great!

However with less filters and more data lines, the Excel export changes to a different format. The data is then all listed in one Excel cell per data line in QV. For example:"

QV table (and desired Excel output):

First Name	Last Name	Age
John	Doe	40
Jane	Doe	40

Excel output:

First Name, Last Name, Age
John, Doe, 40
Jane, Doe, 40

How can I change the "Send to Excel" settings so that every table gives a similar output to the QV table?

Thank you for your help,

Justin

topic Send to Excel format in QlikView

Send to Excel format