topic Re: Export multiple text objects to Excel in QlikView

Export multiple text objects to Excel

Anonymous — Mon, 29 May 2017 03:25:04 GMT

Hi all...

My users have this kind of report (image attached)

and they want Qlikview to show the report exactly like that

Currently I use multiple textboxes to develop it. but i have a problem when i need to export the report to excel.

My questions are:

1. is there any way to export all the values of those text objects to every cell in excel? probably using macro or whatever it is. please kindly explain how

2. is there another alternative (other than using multiple textboxes) to present the report exactly as the image above? I would like to try to customize the straight table but the dimensions are not present in any table. So I have to create them explicitly. What is the best way to do it? Also explain how.

Thanks for your help!

Re: Export multiple text objects to Excel

Anil_Babu_Samineni — Mon, 29 May 2017 04:26:08 GMT

+ tamilarasu‌

Re: Export multiple text objects to Excel

prieper — Mon, 29 May 2017 08:49:08 GMT

pfa

Peter

Re: Export multiple text objects to Excel

Anonymous — Tue, 30 May 2017 03:42:22 GMT

hi pete

Thank you that's a great example

Could you tell me how to add new rows right under 'c. FCT'

Because I tried it and it didnt appear on the table

Re: Export multiple text objects to Excel

Sergey_Shuklin — Tue, 30 May 2017 04:00:41 GMT

Hello, Mike!

In that unusual case you can use a variable which will store all values of your textboxes separated with ";" or other symbol. And all you'll have to do is copy value of this variable in excel and use text by columns option.

Re: Export multiple text objects to Excel

Anonymous — Tue, 30 May 2017 06:35:51 GMT

hey I figured it out

Thank you

Re: Export multiple text objects to Excel

prieper — Tue, 30 May 2017 07:49:19 GMT

You should add any Line (even blanks with ' ') into the "Report"-Table.

And then each expression must consider this line within the PICK-statement, e.g. analogue to the first expression

PICK(Component,
' ',
SUM( {$ <DetailComponent = {a} >} Val),

Where the Line 02 indicates an empty row

Peter

Re: Export multiple text objects to Excel

tamilarasu — Tue, 30 May 2017 08:09:08 GMT

Hi Mike,

Have a look at the below link.

Need Macro to export multiple text-boxes into single excel sheet