Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
stevietm
New Contributor III

Export input box with variable values to QVD

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Export input box with variable values to QVD

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

3 Replies
henrikalmen
Contributor

Re: Export input box with variable values to QVD

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

stevietm
New Contributor III

Re: Export input box with variable values to QVD

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

MVP & Luminary
MVP & Luminary

Re: Export input box with variable values to QVD

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