4 Replies Latest reply: Feb 13, 2018 12:26 PM by Raghav B RSS

    select possible values in filter

    Raghav B

      hi,

       

      How to make qliksense automatically select possible value.

       

      Ex:

       

      in filter there are below values.

       

      12-56

      23-67

      45-88

      67-44

      56-60

       

      for general filter search if we give 56 as input we get only 56-60 in the list.

      what needs to be done if we want to see 12-56 also in that list.

       

      so i need to give *56* to get both 56-60 & 12-56.

      but my data is in thousand how to handle such case.

       

      please let me know of any clues

        • Re: select possible values in filter
          Justin Dallas

          Hello Raghav,

           

          Have you tried bucketing?  This would allow you to have multiple overlapping buckets and a datapoint could belong to more than one of them.

          Orders:
          Load * Inline
          [
              orderId, orderDurationMinutes
              1, 25
              2, 46
              3, 78.9
          ]
          ;
          
          DurationBuckets:
          LOAD orderId , '12-56' AS 'DurationBucket' Resident Orders
               WHERE orderDurationMinutes >=12 AND orderDurationMinutes <= 56
          ;
          LOAD orderId , '23-67' AS 'DurationBucket' Resident Orders
               WHERE orderDurationMinutes >=23AND orderDurationMinutes <= 67
          ;
          

           

           

          Of course there are ways to be more clever and more robust with your buckets, but it's a start.

          • Re: select possible values in filter
            Gysbert Wassenaar

            Add a filter pane object and add the field with the interval values as dimension for the filter pane.

            Click on the Magnifying Glass icon to open the search input field. Enter *56* in the input field and press enter.

            c291258.png