topic Re: Export input box with variable values to QVD in QlikView

Export input box with variable values to QVD

stevietm — Thu, 22 Jun 2017 07:22:01 GMT

Hi All,

I am trying to export a input box to a qvd file, the below script exports a table fine to a qvd file but it does not want to export the input box. Is there something i am missing or does this function not work with input boxes. If this is the case is there an alternative anyone can suggest to do this. I am using macros.

sub ExportKPIs

set obj = ActiveDocument.GetSheetObject("CH83")

obj.Export "D:\QlikView\QVData\QVD\KPI\KPIs.qvd", 4

end sub

Thanks

Regards

STM

Re: Export input box with variable values to QVD

henrikalmen — Thu, 22 Jun 2017 13:14:09 GMT

Perhaps you could populate a table object with the contents of your variable, and then export that table?

Re: Export input box with variable values to QVD

stevietm — Fri, 23 Jun 2017 09:35:45 GMT

Hi Thanks for the reply,

I cannot use a table as the variables i use are high lvl consolidated KPI values (YTD/MTD/YTD TGT). So when i use a table i need to add a dimension which i do not want. I just want the high lvl KPI values.

To give you an idea what i am doing: I have a main menu model with no data in but with buttons that will take you to detailed models, so i want to pull a few high lvl kpis to display on this main menu page from my models. But i do not want to pull all the data because i am running on about 100 mil aggr lines to date. So i want consolidated variables that can be exported to a qvd on post reload of my models then the schedule will run the main menu model and publish on web.

Hope this makes sense.

Regards

STM

Re: Export input box with variable values to QVD

marcus_sommer — Fri, 23 Jun 2017 10:53:49 GMT

You doesn't need mandatory a dimension to create a table-chart like a pivot. Just try it out and put each variable into an expression.

- Marcus