Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Selecting all items within dimensions containing specified values

Hello,

I am new to Qlik Sense. I need to be able to create a dashboard in which a user filters specified values in let's say column 'A'

and then based on that selection the table appears in which we can see all line items contained within group with at least value chosen by a user. So the column 'A' visible in the table will contain also some other values (not specified by the user).

For example if the user chose in the filter pane that he is interested in values equal to '0' in Column A, the resulting table could be as follows:

Column B             Column A

X                          0

X                          1

X                          2

Y                          1

Y                          1

Y                          0

I have no idea how to achieve this 'containing' feature.

Tags (2)
2 Replies
dan_sullivan
Contributor II

Re: Selecting all items within dimensions containing specified values

Not sure I follow what you are trying to do.  But here is what I think you may want to explore.  Create a filter pane on the object you want the user to select from.  Then create a separate table/chart with the dimensions and measures you want visible.  As they filter, the chart will react appropriately.

dwforest
Valued Contributor

Re: Selecting all items within dimensions containing specified values

There is built in functionality ... when filtering a numeric field you can select ranges,e.g.

>=0

<2

>=0<2

No special coding is needed, just user education.