How to export variables into Excel

[vinod2086]

Hi All,

in my application there is a list of variables i want to export all variables into excel file.

while creating the application he has created all variables in excel file and loaded but i don't have access for that excel file.

is there any way to export all variables into excel in qlik sense.

Thanks in Advance.

[arvind_patil]

Hi Kumar,

Could you please give sample code of where she/he load variable throw Excel.

Thanks,

Arvind Patil

[vinod2086]

Hi Arvind,

even am not sure where he has loaded am unable to find.

here i can see list of variables in my application. even am unable to copy that is what i want to export all variables

[arvind_patil]

Hi Kumar,

Please Do following steps:

1) Create an InputBox

2) Add all the variables that you want to copy

3) Copy the InputBox object

4) Paste it in destination document

5) Done. The variables are also copied.

Thanks,

Arvind Patil

[vinod2086]

Hi Arvind,

qliksense we don't have option Input box ryt..

for ref please find attached screen shot  here i want to export all variable expressions.

[vinod2086]

here i have created one text object and copied variable name and exported. now variable expression is exporting.

but my question is can we export multiple variables at a time?

[arvind_patil]

Hi Kumar,

Kindly check with extension may be it will serve your purpose.

Thanks,

Arvind Patil

[deboracornejo01]

anyone can help us with this question??

[robert99]

Hi

"while creating the application he has created all variables in excel file and loaded"

Is the App still loading from the Excel file. But you just don't have access to it

[rwunderlich]

A couple of options, not quite in excel format but you can reformat.  

1. Install the Add Sense Chrome extension https://chrome.google.com/webstore/detail/add-sense/bbiljflfafkaejgdebbnmcohpidgkejj?hl=en  In the app, select Show from the Add Sense menu. The $ in the menu represents the variables, click this and you'll get a list of all variables which you can copy to the clipboard.

2. Install the devtool extension. After adding devtool to a sheet, right-click the gear icon. You can then chose to export the variables in either script or json format. 

Note in both cases you should use Chrome to access the hub.

-Rob