Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

2 Replies
dan_sullivan
Creator II
Creator II

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
Specialist II
Specialist II

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.