topic Re: Re: Export metadata to excel in QlikView

Export metadata to excel

Mon, 11 Aug 2014 06:44:29 GMT

I have a table witch counts all the address id's.

When exporting to excel I would like to export all the data that is link to that address id.

Sush as the steet, the city, number of inhabitants.

Is this possible in qlikview?

Re: Export metadata to excel

ashfaq_haseeb — Mon, 11 Aug 2014 07:48:21 GMT

Hi,

Qlikview can Export one single object to Excel at a time.

For your solution to work you can create a Table box or Straight table with the required content and can export in 1 go.

Regards

ASHFAQ

Re: Re: Export metadata to excel

Mon, 11 Aug 2014 10:14:05 GMT

Is it possible when I make a seperate table that contains this metadata to link this table to the main table data.

I would like to hide this extra information table in my report.

Can I perhaps make a button and when you click it the table with extra info is exported to sql?

I have added a qvw with sample data.

Kind regards,

Katleen

Re: Re: Re: Export metadata to excel

ashfaq_haseeb — Mon, 11 Aug 2014 10:27:27 GMT

Hi,

Check If this can help.

Make any selection and click on export button.

This will Export Data to Excel and you can use that Excel via some ETL tool to write back to your SQL Database.

Note:

QlikView is not meant for Write back to Database.

But there are work arounds .

Check if the below posts helps you.

http://community.qlik.com/docs/DOC-5970

http://community.qlik.com/docs/DOC-6655

Regards

ASHFAQ

Re: Re: Export metadata to excel

Mon, 11 Aug 2014 13:21:00 GMT

I dont want to write back to the database.

I only want to see the extra information that is connected to a certain address_id that is selected in the application.

Kind regards,

Katleen

Re: Re: Re: Export metadata to excel

ashfaq_haseeb — Mon, 11 Aug 2014 13:27:29 GMT

Hi,

Check if that help you.

From the attached application select one value from your first table.

To display details from second table.

Regards

ASHFAQ