6 Replies Latest reply: Jan 19, 2016 4:39 PM by Brandon Golden RSS

    List values of field A based selection of field A based on field B, indirect filter?

    Brandon Golden

      Qlik Sense Question

      I've created an example for clarity:

      I want to see in the visualization all of the fruit that are available from states that offer that fruit.

        

      IDFruitOrigin State
      1AppleNew Jersey
      2ApplePennsylvania
      3AppleNew York
      4AppleCalifornia
      5AppleOregon
      6PearNew Jersey
      7PearPennsylvania
      8PearCalifornia
      9PearNew Mexico
      10PineappleFlorida
      11PineappleTexas
      12PineappleGeorgia
      13PineappleSouth Carolina
      14Pineapple

      New Mexico


      So if I select Apple, the result should be all of the fruit offered by New Jersey, Pennsylvania, New York, California, and Oregon

      • Apple
      • Pear