Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Create an Excel Report with a Button

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

1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Create an Excel Report with a Button

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.

View solution in original post

3 Replies
Highlighted
Master II
Master II

Create an Excel Report with a Button

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

Highlighted
Not applicable

Create an Excel Report with a Button

Thanks Mwoolf

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

Highlighted
Master II
Master II

Create an Excel Report with a Button

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.

View solution in original post