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.
Not applicable

Dynamic scripting based on the file chosen

Hi All,

I want to laod the data from excel based on path entered by the user in inputbox.

while loading i want to check specific conditions (like if column name contains country) and load only specific fields.

Is this possible in load script or a macro is required. can anybody post a sample QVW with this kind of a functionality?

thanks,

Shruthi

4 Replies
MVP
MVP

Re: Dynamic scripting based on the file chosen

Have a look at the attached sample qvw that gives you an idea how to take input from user and use that as parameter in the script load.

Not applicable

Re: Dynamic scripting based on the file chosen

In my case, user will give the excel path, I need to read through the excel and pick only specific fields and reload.

If suppose the excel file has a field ID and country , I should only load country field.

MVP
MVP

Re: Dynamic scripting based on the file chosen

I understood, and thought that my example would show you the direction how to move. It's true that I did not exactly show as per your requirement. Give a try, you would get.

Not applicable

Re: Dynamic scripting based on the file chosen

Hi Shruthi, Your requirement is doable in Qlikview. Please post some sample data and desires o/p you need.

Community Browser