2 Replies Latest reply: Dec 21, 2013 5:36 PM by cl bld RSS

    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

        • Re: Export to Excel QlikView page with filters
          Srikanth P

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

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