Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
burgersurfer
New Contributor II

Importing variables from excel

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)

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Importing variables from excel

Berger,

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

Rich

6 Replies
Employee
Employee

Re: Importing variables from excel

Please clarify the purpose of such an import operation.

Not applicable

Re: Importing variables from excel

Burger,

Check out Karl Pover's post:

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

Rich

Not applicable

Re: Importing variables from excel

hi

I have attached xls file herewith plz find it.

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

Not applicable

Re: Importing variables from excel

Berger,

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

Rich

burgersurfer
New Contributor II

Re: Importing variables from excel

Richard,

This was extremely helpful, thank you very much.

zagzebski
Contributor

Re: Importing variables from excel

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?

Community Browser