topic Re: Importing variables from excel in QlikView

Importing variables from excel

burgersurfer — Wed, 11 May 2011 11:53:49 GMT

Hi,

I am trying to import variables from an excel .xls file into qlikview with no luck.

The format of the excel file is column A, variable name and column B variable contents

columnA columnB

vDays sum(days)

Re: Importing variables from excel

ToniKautto — Wed, 11 May 2011 12:03:34 GMT

Please clarify the purpose of such an import operation.

Re: Importing variables from excel

Wed, 11 May 2011 13:03:01 GMT

Burger,

Check out Karl Pover's post:

http://community.qlik.com/message/89749#89749

Rich

Re: Importing variables from excel

Wed, 11 May 2011 13:11:17 GMT

I have attached xls file herewith plz find it.

with this excel file you can export all variable in xls.

Re: Importing variables from excel

Wed, 11 May 2011 13:27:11 GMT

Berger,

Based on Karl's post this is the routine I now use for importing variables in the script

Rich

Re: Importing variables from excel

burgersurfer — Wed, 11 May 2011 15:06:12 GMT

Richard,

This was extremely helpful, thank you very much.

Re: Importing variables from excel

zagzebski — Thu, 17 Jul 2014 16:21:54 GMT

Richard -

Found this post from a while back so doon't know if you are still responding. If so I really like your example above. However is there any way to get the "usage" field into the "comments" section of the variables or at least is available when hovering over the expression?

Re: Importing variables from excel

carlcimino — Fri, 22 Mar 2019 19:46:46 GMT

Anyone have a solution for getting the usage field into the comments section of the variable?

Re: Importing variables from excel

james_butler — Thu, 27 Jun 2019 10:18:15 GMT

Top work!! Thank you