Unable to export more than 20 columns in 'Comma Seperated CSV - Client Side'

[AbhishekShetty08]

Description

Unable to export more than 20 columns in 'Comma Separated CSV - Client Side'. This problem does not exist in other 3 option (Open XML, Comma Separated CSV and Tab Separated CSV).

Steps to Reproduce

1. Change values of 'max' in dimensions and measure variable to have anything more than 20.
2. Add more than 20 dimensions to extension in chart.
3. Select 'Comma Seperated CSV - Client Side' in 'Export Defination -> Format'
4. Click done and Export CSV.

Expected behavior

Exported CSV should contain value of all added dimensions and Measures.

Actual behavior

Exported CSV has only headings and no data starting 21st dimension/measure (column).

Environment

QlikSense September 2017

Operating system

[ x] Windows 10

##### Qlik Sense

[x ] Desktop

##### Browser

[x ] Chrome
[x] Edge

### Versions

* Extension version: Bump 1.3.5
* Browser: Chrome / Edge
* Qlik Sense: September 2017
* Operating system: Windows 10
* [Other relevant versions]

[MeghaKatwala]

Hi Abhishek,

I can add only 10 dimension/columns for export extension. I have qWidth: 20 and qHeight :500 and also recreated my visualization but I still can download only 10 columns.

Can you please let me know how can I download 20 columns using this extension?

[stefanwalther]

That's a setting here: https://github.com/stefanwalther/sense-export/blob/master/src/initialproperties.js

[stefanwalther]

I highly recommend not to use the client-export, why do you want to use it @AbhishekShetty08 ?

See here for further explanation of the client-side export functionality: https://github.com/stefanwalther/sense-export#a-note-on-comma-separated-csv---client-side

[hvdbunte]

@stefanwalther Can you comment in more detail on how to change this setting? Because I tried to change this qWidth: 20 setting to 30 but I am not able to add more then 10 dimensions.

We would like to export this to Excel.
We use Qlik sense april 2019 sp4.

[JeromeHoen]

@stefanwalther Can you comment in more detail on how to change this setting? Because I tried to change this qWidth: 20 setting to 30 but I am not able to add more then 10 dimensions.

We would like to export this to Excel.
We use Qlik sense april 2019 sp4.

I had the same issue. The correct fix was to make the modification in the file properties.js
You have to change the following part with the new maximum number of dimensions and measures:

dimensions={uses:"dimensions",min:0,max:10},measures={uses:"measures",min:0,max:10}

CTRL+F and look for the number "10"

[hvdbunte]

@stefanwalther Can you comment in more detail on how to change this setting? Because I tried to change this qWidth: 20 setting to 30 but I am not able to add more then 10 dimensions.
We would like to export this to Excel.
We use Qlik sense april 2019 sp4.

I had the same issue. The correct fix was to make the modification in the file properties.js
You have to change the following part with the new maximum number of dimensions and measures:

dimensions={uses:"dimensions",min:0,max:10},measures={uses:"measures",min:0,max:10}

CTRL+F and look for the number "10"
Hi JeromeHoen,

Thanks a lot! This worked perfectly.

hvdbunte