topic Re: Exporting multiple text objects to Excel in QlikView

Exporting multiple text objects to Excel

rahulhv1 — Thu, 06 Aug 2015 07:42:48 GMT

Hi Mates,

We have developed an application with multiple text objects. say around 50. I wish to provide a button on the said application which will export all the values of text objects to excels. Could any one please share me the codes of the macro for the same. In below screen shot. All are the text box objects and I want to export all the objects as per the format to Excel File.

Re: Exporting multiple text objects to Excel

jonathandienst — Thu, 06 Aug 2015 07:52:42 GMT

This will be quite tricky - there is no easy way iterate over the text boxes and to link the text box to a cell in Excel - is it not possible to create a table with all the content and export that instead?

Re: Exporting multiple text objects to Excel

rahulhv1 — Thu, 06 Aug 2015 08:00:51 GMT

Thanks for your reply Jonathan, The application which I have developed is little complicated and hence could not formulate table for the same and hence used Text objects. My idea is to write some code using loop to export the same to Excel file.

Re: Exporting multiple text objects to Excel

jonathandienst — Thu, 06 Aug 2015 08:41:00 GMT

That's not the way I would approach the issue, but good luck.

Re: Exporting multiple text objects to Excel

Colin-Albert — Thu, 06 Aug 2015 08:47:34 GMT

Not easy to do directly in QlikView. As Jonathon suggests either create your data as a table rather than separate text boxes, or an add-in like NPrinting could create an Excel table from your QlikView app.

Re: Exporting multiple text objects to Excel

simondachstr — Thu, 06 Aug 2015 08:51:28 GMT

You need to create a (highly customized) straight table in this case. Anything else is QlikView bad practise. 50 text boxes are horrendous for the click performance.

Re: Exporting multiple text objects to Excel

rahulhv1 — Thu, 06 Aug 2015 11:47:09 GMT

At least can one share the code for exporting text object value or 3-4 object to excel?

Re: Exporting multiple text objects to Excel

rahulhv1 — Thu, 06 Aug 2015 14:24:40 GMT

Hi All,

I have created an excel sheet in which I have written all the parameters that I want in Col. A and in Col. B , I have written expressions which gives the value of each parameter , my question is, in qlikview , can I use Col. B as an expression. Example given as under.

Inupt

Required Output :