topic Export to Excel QlikView page with filters in QlikView

Export to Excel QlikView page with filters

Sat, 21 Dec 2013 21:02:08 GMT

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

Re: Export to Excel QlikView page with filters

Sat, 21 Dec 2013 21:47:04 GMT

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

Re: Export to Excel QlikView page with filters

Sat, 21 Dec 2013 22:36:22 GMT

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' ?