Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Right Click on the Table box and select send to Excel or Export options.
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' ?