5 Replies Latest reply: Oct 4, 2014 1:33 PM by Tom Brown RSS

    Filtering data without using a filter pane

      Hi,

       

      I want to filter data from a chart (just remove a some data based on a simple text based dimension) but can't seem to do it without a filter pane.  I don't want the pane to take up any room on my sheet (and don't ever need to change the filter)

       

      Cheers

       

      Tom

        • Re: Filtering data without using a filter pane
          Michael Tarallo

          Hi Tom,

           

          With Qlik Sense - you could use the Global Smart Search option - where you can type in the text value  - or the Global Selections panel. This will enable selection possibilities without the need for a filter list box to be displayed on the sheet.

           

          If you have a minute check these short videos out that demonstrate this and more.

           

           

          Let me know if this helps you.

           

          Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

           

          Regards,

           

          Mike

            • Re: Filtering data without using a filter pane

              Thanks Mike,

               

              Perhaps I could have been clearer!

               

              I have one data set, a list of invoices, each invoice has a type associated with it.  Assume we have type A and type B invoices.  I actually want two charts on my dashboard, one showing invoices of Type A and one showing invoices of Type B.  I think global search will affect both charts. 

               

              So I want to set a design time filter which is preserved for each chart.

               

              Cheers

               

              Tom

                • Re: Filtering data without using a filter pane
                  Michael Tarallo

                  Ok Tom thanks. Let me see if one of my colleagues can chime in here.

                   

                  jpe can you take a quick look?

                   

                  Thank you

                   

                  Mike

                    • Re: Filtering data without using a filter pane
                      Jonathan Poole

                      Two easy options.

                       

                      Both methods are achieved by adjusting the existing Measure formula. If you have multiple measures, apply the same technique to all measures in the chart.

                       

                      1. Set Analysis   (shown in middle , it puts a filter into the chart object only and is done within the measure/expression formula ).   The SET expression is very powerful and is described in the help under 'SET ANALYSIS'.  In the sample expression i wrote, the chart will 'listen' to all filters that the user makes and regardless of any filter applied on the Type field, will apply Type='A' to the chart that the measure exists in.  There are many possibilities.

                       

                      2.Good old 'If Statement' & 'hide zero values'    (shown at bottom, it effectively filters the chart object by only counting values where Type in this case ='A'.  In this situation you also have to disable 'show zero values' under the add-on section oft he chart properties.

                       

                      I can also post the .QVF if that will help further.

                       

                      Capture.PNG.png