topic Re: How can I extract different tables in one excel sheet in QlikView

How can I extract different tables in one excel sheet

Anonymous — Sun, 21 Jan 2018 02:11:37 GMT

I am working with data loaded onto qlikview, I have created multiple tables

How can i extract all these out in one click onto an excel sheet, can someone please help

Re: How can I extract different tables in one excel sheet

Anil_Babu_Samineni — Sun, 21 Jan 2018 02:37:07 GMT

PFA

Re: How can I extract different tables in one excel sheet

Anonymous — Sun, 21 Jan 2018 05:05:35 GMT

thank you that is correct, how can i do this on my sheet . what would i need to change .

do you have an email

Re: How can I extract different tables in one excel sheet

Anil_Babu_Samineni — Sun, 21 Jan 2018 05:13:25 GMT

The only changes you need. Go to Ctrl + M and change Path your need.

Go to Setting -> Doc properties (Short cut {Ctrl + Alt + D}) - Security - "Macro Override Security" should be enabled.

Re: How can I extract different tables in one excel sheet

Anonymous — Sun, 21 Jan 2018 23:31:22 GMT

thank you, how can I keep the module CTRL + M From loading after run.

Also how can I change the heading colors to cover all columns

Also how can I enable Wrap Text within this

Thank you

Re: How can I extract different tables in one excel sheet

Anil_Babu_Samineni — Mon, 22 Jan 2018 00:39:19 GMT

Do you mean, You want to open Ctrl + M once Reload() got success?

I can work left of 2 parts in the evenings, As i don;t have Software in handy.

Re: How can I extract different tables in one excel sheet

Anonymous — Mon, 22 Jan 2018 02:08:06 GMT

alright thank you

Re: How can I extract different tables in one excel sheet

tamilarasu — Mon, 22 Jan 2018 03:18:27 GMT

Let us know if you have any issues.

Re: How can I extract different tables in one excel sheet

Anonymous — Mon, 22 Jan 2018 12:28:33 GMT

Tamil babu said he will answer the 2 parts which were to help me . that is why i said thank you

Also how can I change the heading colors to cover all columns

Also how can I enable Wrap Text within this

Re: How can I extract different tables in one excel sheet

Anil_Babu_Samineni — Mon, 22 Jan 2018 14:37:31 GMT

As i promised, I disabled this? Looks like working

'sCaption=obj.GetCaption.Name.v

'oSH.Range("A" & num_rows).Font.Bold = True

'oSH.Range("A" & num_rows+3).Value = sCaption

Re: How can I extract different tables in one excel sheet

Anonymous — Tue, 23 Jan 2018 03:18:03 GMT

I would like to be able to merge the top most column and color it black with white font , like this .

and how can i resize the rows in the output .

Re: How can I extract different tables in one excel sheet

Anonymous — Tue, 23 Jan 2018 03:20:53 GMT

1 - merge top row and give the column the header title

and

2. the rows height output is very big and out of proportion, how can i have it more smaller and sized by data

Re: How can I extract different tables in one excel sheet

tamilarasu — Tue, 23 Jan 2018 04:53:57 GMT

Hi Mike,

Have a look at the attached file.

Re: How can I extract different tables in one excel sheet

Anonymous — Tue, 23 Jan 2018 21:23:44 GMT

THank you for answering, I am sorry, I guess I was not clearer.

1. I am trying to merge the header and give it the tables name for each table. (not just the top )

2. I like the capability to be able to size the column, I want to keep it, I would just like to autosize rows

Thank you

Re: How can I extract different tables in one excel sheet

tamilarasu — Wed, 24 Jan 2018 09:15:37 GMT

Sorry, I couldn't get you. Could you please attach expected output format against the above attached qvw file (Press export button and do the expected formatting manually and attach here) in excel format. It will be helpful to help you quickly.