Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sarahallen1
Creator II
Creator II

I want to load the FORMULAE from Excel cells not the values

Is this possible?  I want to define fields etc in my LOAD statement as usual, but for the field values I want to read in the formula in each Excel cell, rather than the value.

Any ideas would be very welcome!

Thanks.

23 Replies
tamilarasu
Champion
Champion

Sarah,

       First, you need to take a copy of your source folder and need to run the macro. Hope you need your source files later. So, we can do all the replacing work in a copied files. Once we ran the macro, all files will be replaced with new changes. Now, you can load these files into qlikview without any issues.

I guess we can incorporate the vba into Qlikview and can call them while exection of load script. But I haven't tried this method.

sarahallen1
Creator II
Creator II
Author

That would be great, thanks Petter.  Much appreciated.

sarahallen1
Creator II
Creator II
Author

Thanks Tamil that makes sense.

sarahallen1
Creator II
Creator II
Author

Hi petter-s‌,

This old requirement has resurfaced - I need to analyse the formulae in c. 500 Excel spreadsheets.  Back in 2016 you suggested you might have a sample app as I couldn't get your VBScript for UnZip to work.  Is this something you can provide now or give further help on? Very much appreciated.

Thanks,

Sarah