Export multiple text objects to Excel

[Anonymous]

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!

[Anil_Babu_Samineni]

+ tamilarasu‌

[prieper]

pfa

Peter

[Anonymous]

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

[Sergey_Shuklin]

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.

[Anonymous]

hey I figured it out

Thank you

[prieper]

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

[tamilarasu]

Hi Mike,

Have a look at the below link.

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