topic Re: how to filter in Table Box in QlikView

how to filter in Table Box

Anonymous — Fri, 02 Dec 2011 18:05:09 GMT

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

how to filter in Table Box

swuehl — Fri, 02 Dec 2011 23:46:40 GMT

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

Re: how to filter in Table Box

Thu, 06 Sep 2012 08:47:10 GMT

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!

Re: how to filter in Table Box

Edge — Thu, 12 Sep 2019 09:06:54 GMT

Hey Stefan,

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