topic Re: export sheet objects in QlikView

export sheet objects

Johnnyg248 — Wed, 25 Nov 2020 16:16:04 GMT

I know if I do properties on a sheet I can do a properties and go to the objects tab I can see

object Type caption showmode

what I was hoping to do was export these fields for all the objects on the sheet in addition to

the text (I have several that have an expression to get the text to display), and any formula used for conditional show

Right now having to go through each object 1 by 1 which is quite time consuming

Re: export sheet objects

MikeW — Tue, 01 Sep 2020 22:31:08 GMT

I think you can load from a qvw as an xml format and it will read all the metadata on the objects in the qvw.

Re: export sheet objects

Johnnyg248 — Wed, 02 Sep 2020 12:51:13 GMT

Thanks for the response

Not sure I'm following your suggestion

Perhaps an example?

Thanks!

Re: export sheet objects

Brett_Bleess — Wed, 16 Sep 2020 14:42:46 GMT

If you open the QVW file with say NotePad++ and scroll down toward the bottom of the file, you will see the meta data of the application there, I believe that is what the poster was referring to. I am pretty sure our Governance Dashboard app reads this as well to get information on the apps, so that might be worth checking over too in order to see if that might get you what you want, and if not, you can check the script in it for how we are pulling that...

https://help.qlik.com/en-US/governance-dashboard/Content/QV_GovDashboard/What.htm

That is the Help link, the link to download is in there as well, just FYI, but I hope this puts you on the right track.

Regards,
Brett