Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
valnod_90
Contributor III
Contributor III

Problem with filter selection

Hi everyone,

i have a problem with a filter pane and a table.

I think is not easy so i'll try to be as clearer as possible.

The filter contains all the features of sell orders, the table contains all the sell orders.

When i select from the filter two or more features i'd like to see in the table, as result, only the orders that have all the features that i've selected at the same time.

That's the point, i need to have alla the features simoultaneously.

So, for example, if i select as color, from the filter pane: green, red and yellow, in the table i'd like to see an order ONLY if it has all the three features togheter, or nothing.

If i select six features i'd like to see an order only if it has all the six features or nothing, and so on...

Is there a way to do it?

6 Replies
niclaz79
Partner - Creator III
Partner - Creator III

Hi,

Can you explain your data model? Can an order have multiple features? are the features all in one column etc?

This is hard to explain how to do without knowing what your data looks like.

shanky1907
Creator II
Creator II

Did you try the below approach:

If the expression in your table is like Sum(Sales).

Try this:

Sum{<Color=p(Color)>Sales}

valnod_90
Contributor III
Contributor III
Author

I'll try, the data model is quite easy because is just a table with columns and rows.

An order has more features and these are all in a single column of the table.

You can imagine a column with the number of the order and a column with the features, that's all.

valnod_90
Contributor III
Contributor III
Author

unfortunately i don't have any expression in my table but just dimensions

shanky1907
Creator II
Creator II

Tale table chart(not table box) as the object.

Then Take color as expression and try with above expression plz

valnod_90
Contributor III
Contributor III
Author

I tried but it doesn't work.