Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Export to Excel QlikView page with filters

Hi

I have a page with filters and two Table Boxes. I would like to export all of these data in Excel, so that I am able to reload them afterwards and keep the filters' "logic".

In other words, from the set of filters and Table Boxes, I would like to export the data so that back into a blank QLikView document I get the same as the original page.

Of course this is not possible with Export To Excel on right click, since there I will only have option to export one of the Table Boxes.

How can I proceed ?

regards

2 Replies
Not applicable

Re: Export to Excel QlikView page with filters

Right Click on the Table box and select send to Excel or Export options.

Not applicable

Re: Export to Excel QlikView page with filters

Thanks

If i do as you suggest, I

- open existing sheet with filters and Table Boxes

- right click on filters and export to separate excel sheets

- right click on Table Boxes and export to separate excel sheets

- open a blank QLikView document

- Edit script and load all the excel tables (from filters and Table Boxes)

- Right click -> new sheet object -> list with data from one filter

- Right click -> new sheet object -> Table Box with data from one Table Box

I obtain, in the new QLikView document, one list box and one Table box. In the original document, the 'list' was a filter. If i clicked on one of the filters, i obtained this filter to be applied on the Table Box. In the new document, if i click on the list on one item, it does not impact/filter the Table Box.

How to export/re-import filters and Table Boxes as to keep the 'filter's logic' ?