Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mayuridg
Contributor

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
Valued Contributor III

Re: Variables into Excel

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

5 Replies

Re: Variables into Excel

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

HTH

Best,

Sunny

mayuridg
Contributor

Re: Variables into Excel

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?

Re: Variables into Excel

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

MVP
MVP

Re: Variables into Excel

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
Valued Contributor III

Re: Variables into Excel

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