topic Re: Appending multiple tables and exporting them as one table to Excel in QlikView

Appending multiple tables and exporting them as one table to Excel

Mon, 04 Aug 2014 06:27:53 GMT

Hi,

I want to append 3 Tables (created on the front end ) from QV and want to export them to excel as one single table ?
Thanks,

Jaskirat

Re: Appending multiple tables and exporting them as one table to Excel

senarath — Mon, 04 Aug 2014 06:37:09 GMT

Hi,

What you could do is that;

01.Create a Report incorporating 03 reports under Reports menu

02. You could create a single table which includes content of all 03 reports and keep it either minimized or show dynamically until when you want to export to excel.

thanx

Re: Appending multiple tables and exporting them as one table to Excel

Mon, 04 Aug 2014 06:41:12 GMT

Hi,

Thanks for your prompt reply!
But the issue is that we have 3 straight tables on frontend with similar fields, just want the data from all 3 to get appended when we export all three to excel....

Re: Appending multiple tables and exporting them as one table to Excel

ashfaq_haseeb — Mon, 04 Aug 2014 06:47:04 GMT

This is not possible directly.

You have to go with some macro.

Regards

ASHFAQ

Re: Appending multiple tables and exporting them as one table to Excel

vardhancse — Mon, 04 Aug 2014 06:48:24 GMT

1. if you want to load only one single table by merging all the 3 tables, then join the tables based on the common field.

and then you can create one table box with all the fields.

then we can export in to excel sheet from front end

2. if you want to export after loading in to 3 separate table, there must be some relation between tables.

the in the table box we can select required fields and can export in to excel

Re: Appending multiple tables and exporting them as one table to Excel

Mon, 04 Aug 2014 06:57:27 GMT

Hi,

Thanks ! I need to simply export the tables to excel and append them .
Constraints are :
-Use a single app, cannot create another to app to load 3 tables and apply the merge.
-Cannot Use MAcros.
Thanks,
JAskirat

Re: Appending multiple tables and exporting them as one table to Excel

senarath — Mon, 04 Aug 2014 07:09:10 GMT

Hi.

You mean to say that you want all columns in that 03 report to amalgamate into a single report ?

01.You could think of using Concatenation at script level

02. As I mentioned, could develop a new report in such a manner that includes dim and expressions of other 03 reports in common if the fields are similar

If you could post a example, it will be helpful for any body who is going to reply you.[including me :-)]

Sorry if I have misunderstood your requirement.

Re: Appending multiple tables and exporting them as one table to Excel

vardhancse — Mon, 04 Aug 2014 07:11:30 GMT

how you are loading the tables in the app.

we can use table box: and add the required fields and can export in to excel