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.
vikasmahajan
Honored Contributor III

Input From Excel and update it and loading into Qlikview 11

Dear All,

I have excel which is having certains GLS along with some parameters defined we load into qlikview and

deliver some reports in finance , Now problem is that if new GL arrive then we need to update the

excel sheet and then load into qlikview ,

Whether it is possible to give user GRID load all excel sheet as input and user will all/modify / Delete

excel sheet and save the excel through qlikview only not manually.

Whether it is possible in Qlikview Please give valuable suggetions.

Thanks

Vikas

2 Replies
sushil353
Honored Contributor II

Re: Input From Excel and update it and loading into Qlikview 11

hi vikas,

Your requirement is not clear.

Could you please add some example or file for better understanding and faster resolution.

As of now the functionality you are talking about can be accomplished using macros.

HTH

Sushil

vikasmahajan
Honored Contributor III

Re: Input From Excel and update it and loading into Qlikview 11

Hii Sushil

Thanks for your Input , I have excel file with GL goruping which holds GL and some flags related to PL & BS

when new GL will come or there is some change in schedules then we have to change in excel file, insted of doing in excel file can we load this excel file into qlikview Grid and save the modified chages in excel with revised data.

Please advise. If you have macro for the same can you share please

Vikas

Community Browser