Importing variables from excel

[burgersurfer]

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)

[ToniKautto]

Please clarify the purpose of such an import operation.

[#3]

Burger,

Check out Karl Pover's post:

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

Rich

[#4]

hi

I have attached xls file herewith plz find it.

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

[#5 · Accepted solution]

Berger,

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

Rich

[burgersurfer]

Richard,

This was extremely helpful, thank you very much.

[zagzebski]

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?

[carlcimino]

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

[james_butler]

Top work!! Thank you