Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

suvrojit
New Contributor

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

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.

2 Replies

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

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

suvrojit
New Contributor

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

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!!

Community Browser