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

[Anonymous]

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,

dim1	dim2
dog	cat
cow	goat
elephant	dog

User selects dog from a list only showing below values,

dog

cow

elephant

Data shown in report:

dim1	dim2
dog	cat
elephant	dog

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.

[sunny_talwar]

May be create a link table in which you create a new field for selection purposes.

[Anonymous]

Thanks. We solved it using field from a separate table as filter pane, then getting the selection value with getfieldselections and putting it in a variable. Then filtered another dimension using set analysis with only function and the variable and converted the dimension into a measure.It works fine!!

[edu83st]

Can you post your file? please!

[sagnikrana]

If you could post your file or the logic then it would be great!

Thanks!