topic Re: Problem with filter selection in App Development

Problem with filter selection

valnod_90 — Wed, 03 Oct 2018 12:48:43 GMT

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?

Re: Problem with filter selection

niclaz79 — Wed, 03 Oct 2018 12:56:28 GMT

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.

Re: Problem with filter selection

shanky1907 — Wed, 03 Oct 2018 13:09:51 GMT

Did you try the below approach:

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

Try this:

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

Re: Problem with filter selection

valnod_90 — Wed, 03 Oct 2018 13:24:41 GMT

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.

Re: Problem with filter selection

valnod_90 — Wed, 03 Oct 2018 13:26:20 GMT

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

Re: Problem with filter selection

shanky1907 — Wed, 03 Oct 2018 14:08:49 GMT

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

Then Take color as expression and try with above expression plz

Re: Problem with filter selection

valnod_90 — Wed, 03 Oct 2018 14:20:44 GMT

I tried but it doesn't work.