Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
valnod_90
New 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
Partner
Partner

Re: Problem with filter selection

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

Re: Problem with filter selection

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
New Contributor III

Re: Problem with filter selection

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
New Contributor III

Re: Problem with filter selection

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

shanky1907
Contributor II

Re: Problem with filter selection

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

Then Take color as expression and try with above expression plz

valnod_90
New Contributor III

Re: Problem with filter selection

I tried but it doesn't work.