Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikAngel
Partner - Creator
Partner - Creator

Variables into Excel

Hi,

I have 50 Variables, i need that variable name & Variable Expression in to Excel.

How to do it.?

please suggest.

Regards,

Mayuri

1 Solution

Accepted Solutions
vardhancse
Specialist III
Specialist III

hi,

Create one input box

add all the variable from available variables to displayed variables.

in caption enable send to excel (Check box)

and click on OK

now input box will be displayed with all the available variables in dashboard.

right click on input box->Send to excel

All the variables in dashboard are exported into excel sheet

View solution in original post

5 Replies
sunny_talwar

Take a look at this thread: Re: load variable in qlikview

HTH

Best,

Sunny

QlikAngel
Partner - Creator
Partner - Creator
Author

Hi Sunny ,

Thanks for your response.

i have QV Application in that i have used 50 application,

Now i want is from that application all variables in to Excel.

How to do that?

sunny_talwar

The best way I can recommend to that would be to use Rob's Document Analyzer application which would add all your variables to a straight table or table box (not certain which one), which can then be easily exported into Excel.

Tools | Qlikview Cookbook

HTH

Best,

Sunny

maxgro
MVP
MVP

try using the search (upper right)

https://community.qlik.com/search.jspa?q=load+variable+from+excel

or google for

qlikview load variable excel

you can find some video too

vardhancse
Specialist III
Specialist III

hi,

Create one input box

add all the variable from available variables to displayed variables.

in caption enable send to excel (Check box)

and click on OK

now input box will be displayed with all the available variables in dashboard.

right click on input box->Send to excel

All the variables in dashboard are exported into excel sheet