topic Re: exel macro data to qlikview in QlikView

exel macro data to qlikview

Sun, 22 Jul 2012 19:37:49 GMT

Hi! I have a question. How to load results(sums,ext.) of exel macro in Qlikview ? I only need results (otherwise it would take a long time to just load whole exel table over and over)

Re: exel macro data to qlikview

deepakk — Sun, 22 Jul 2012 19:45:17 GMT

Hi,

If possible,I would suggest you to store the excel data in QVD and then pull the data into application.

So loading data again and again would be faster...!!!

Deepak

Re: exel macro data to qlikview

Sun, 22 Jul 2012 20:45:11 GMT

Unfortunately , there are too many exel tables , data in them will be changed often and also exel macros will be used often... Macro generates some numbers in exel , generated numbers (results) are imported in qlikview. Any idea how to do that?

Re: exel macro data to qlikview

nagaiank — Sun, 22 Jul 2012 22:15:57 GMT

Is it possible to define the Excel macros so that all the data to be loaded in Qlikview are in one sheet (say Sheet1)? If there are multiple Excel sheets, you can have script to load Sheet1 of each Excel file into Qlikview.

Re: exel macro data to qlikview

Anonymous — Sun, 22 Jul 2012 22:42:47 GMT

Are the "result" cells identified somehow in Excel?
For example, if there is a row identified as "Result" in column A, you can load like this:

LOAD
B as [Total Sum],
C as [Total Avg.],
D as [Result ...],
...
WHERE A = 'Result';

Regards,
Michael

Re: exel macro data to qlikview

Mon, 23 Jul 2012 07:47:41 GMT

I have attached part of macro file in my original post to make it easier to see my problem... @Michael Solomovich - I've tried but with no luck.