Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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
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.
Check if that help you.
From the attached application select one value from your first table.
To display details from second table.
