topic conditional show and export metadata (example qvw) in QlikView https://community.qlik.com/t5/QlikView/conditional-show-and-export-metadata-example-qvw/m-p/654669#M239191 <HTML><HEAD></HEAD><BODY><P>Hello guys!</P><P></P><P>I attached a sample qvw file for more clarity.</P><P></P><P>The main table shows the number of inhabitants for each category (business,civilian,..)</P><P>When exporting to excel I would like to have all the underlying information of that civilian.</P><P></P><P>(Each civilian is an address_id)</P><P></P><P>Doing this with macro's is to difficult for me.</P><P></P><P>So I made a second table with all the information I want to see in excel.</P><P></P><P>But how do I link this information to the first table?</P><P>Secondly, I would like to hide this table.</P><P></P><P>Perhaps make a button and when you click the button the data of that table is sent to excel.</P><P></P><P>Can anyone give me a hand with this?</P><P></P><P>Kind regards,</P><P>Katleen</P></BODY></HTML> Mon, 11 Aug 2014 09:27:31 GMT 2014-08-11T09:27:31Z conditional show and export metadata (example qvw) https://community.qlik.com/t5/QlikView/conditional-show-and-export-metadata-example-qvw/m-p/654669#M239191 <HTML><HEAD></HEAD><BODY><P>Hello guys!</P><P></P><P>I attached a sample qvw file for more clarity.</P><P></P><P>The main table shows the number of inhabitants for each category (business,civilian,..)</P><P>When exporting to excel I would like to have all the underlying information of that civilian.</P><P></P><P>(Each civilian is an address_id)</P><P></P><P>Doing this with macro's is to difficult for me.</P><P></P><P>So I made a second table with all the information I want to see in excel.</P><P></P><P>But how do I link this information to the first table?</P><P>Secondly, I would like to hide this table.</P><P></P><P>Perhaps make a button and when you click the button the data of that table is sent to excel.</P><P></P><P>Can anyone give me a hand with this?</P><P></P><P>Kind regards,</P><P>Katleen</P></BODY></HTML> Mon, 11 Aug 2014 09:27:31 GMT https://community.qlik.com/t5/QlikView/conditional-show-and-export-metadata-example-qvw/m-p/654669#M239191 2014-08-11T09:27:31Z