topic Re: Variables into Excel in QlikView

Variables into Excel

QlikAngel — Wed, 05 Aug 2015 09:00:05 GMT

Hi,

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

How to do it.?

please suggest.

Regards,

Mayuri

Re: Variables into Excel

sunny_talwar — Wed, 05 Aug 2015 09:05:36 GMT

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

HTH

Best,

Sunny

Re: Variables into Excel

QlikAngel — Wed, 05 Aug 2015 09:12:03 GMT

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

sunny_talwar — Wed, 05 Aug 2015 09:15:22 GMT

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

Re: Variables into Excel

maxgro — Wed, 05 Aug 2015 09:16:06 GMT

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

Re: Variables into Excel

vardhancse — Wed, 05 Aug 2015 09:19:02 GMT

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