how to filter in Table Box

[Anonymous]

example paymentStatus <>'Delivered' like that.. i will static word in expression but it is not work

[swuehl]

Unfortunately, you can't use an expression to filter in the table box object.

You could use a straight table chart instead, maybe with a calculated dimension

=if(paymentStatus <> 'Delivered', paymentStatus)

then add your other dimensions or expression as you like.

Instead of the calculated dimension, you could use set analysis in all your expressions to limit the results, for example, use paymentStatus as dimension and

=only({<paymentStatus -= {'Delivered'}>} paymentStatus)

(You could hide the expression in presentation tab, so you get only one column paymentStatus).

Or you could use a table box, but filter using selection, maybe triggered by a button action.

Hope this helps,

Stefan

[#3]

Hi Stefan,

I've a similar problem. I would like to filter a tabel box with a expression and understand what it is not possible. So I've create a straight table but I doesn't work. Maybe you have a suggestion to whrite my expression. The expression look like:

if ({$<OrderDate={"<=$(#=max(OrderDate))"}, CustomerChange={'1'}>})

-

if ({$<OrderDate={"<=$(#=max(OrderDate))"}, CustomerChange={'-1'}>})

Thanks!

[Edge]

Hey Stefan,

This answer have helped me solve my problem. I have liked it. Hope the author can mark it as answer.