Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
It would be necessary to create a csv or xlsx file from a pivot table type object every Monday morning. I wrote the corresponding macros and made them run when the file was opened. Everything worked fine, but I would like to have this kind of data export during the nightly data refresh, which is done using the QV Management Console. I used such an update many years ago, when the Management console was not yet used for updating. It seems that it can't be done now, so instead of making QlikView better, the update has made it worse. Why has such an opportunity been taken away? Maybe it can be done somehow, maybe someone can advise. I have found recommendations to write a script to send this, but at the moment there is no table yet. You could, of course, write a more complex section of script that would create a table with the same structure as the table, but that doesn't make sense, because in this case it's better to write a suitable sql query and read the data directly into an excel file, and QlikView is then useless. We pay large sums of money for the development of QlikView every year, but QlikView is rather in regression and all development is aimed at QlikSense, why such discrimination.
Riho
