Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vinod2086
Creator II
Creator II

How to export variables into Excel

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.

9 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Kumar,

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

Thanks,

Arvind Patil

vinod2086
Creator II
Creator II
Author

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
Partner - Specialist III
Partner - Specialist III

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
Creator II
Creator II
Author

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.

123.jpg

vinod2086
Creator II
Creator II
Author

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
Partner - Specialist III
Partner - Specialist III

Hi Kumar,

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

Thanks,

Arvind Patil

deboracornejo01
Contributor
Contributor

anyone can help us with this question??

robert99
Specialist III
Specialist III

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.

2019-12-13_11-25-11.png

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. 

2019-12-13_11-28-40.png

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

-Rob