Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
stevietm
Creator
Creator

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
marcus_sommer

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

View solution in original post

3 Replies
henrikalmen
Specialist II
Specialist II

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

stevietm
Creator
Creator
Author

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

marcus_sommer

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