topic Create an Excel Report with a Button in QlikView

Create an Excel Report with a Button

Mon, 21 Nov 2011 13:17:37 GMT

Hi Guys,

I wish to create a button on my spreadsheet that does the following :

Retains the current selections

Pulls specifc Field Names

Exports to excel.

I can build the "Report" within a Table Box, but I dont wish to have a tablebox sitting on the page ,

Can anyone advise or offer an alternative ?

Thanks

Create an Excel Report with a Button

m_woolf — Mon, 21 Nov 2011 15:21:07 GMT

Build the report in a table box and hide the table box.

Create an Excel Report with a Button

Tue, 22 Nov 2011 10:05:47 GMT

Thanks Mwoolf

Do you know what is the best way to hide a table box ?

Create an Excel Report with a Button

m_woolf — Tue, 22 Nov 2011 10:57:18 GMT

Under Properties, on the Layout tab. Set a condition for showing the object. Probably best to create a variable something like: vShowTable = 'True' when you want to see the table and = 'False' when you want to hide it.