2 Replies Latest reply: Jun 15, 2018 3:35 AM by Subhrajit Roy RSS

    Is it possible to filter on two dimensions based on a single selection?

    Subhrajit Roy

      I have a report with two columns, dim1 and dim2. In my prompt page I want user to be able to select any value(s) of dim1 and then see the report for only the selected dim1 value(s) and their corresponding dim2 values.

      The catch is, if a value is not in dim1 but present in dim 2, that should also show up on the report.

      e.g,

       

      dim1dim2
      dogcat
      cowgoat
      elephantdog

       

      User selects dog from a list only showing below values,

      dog
      cow

      elephant

       

      Data shown in report:

       

      dim1dim2
      dogcat
      elephantdog

       

      The condition is where dim1=user_selection or dim2 = user_selection.

       

      I have based the prompt on a filter pane which takes data from dim1 and the moment dog is selected on dim1, it automatically filters out elephant in dim1 so it would not show dog in dim2 in the report.

       

      Is there a way to achieve this in Qliksense?

       

      Thank you.