topic Filter table object in QlikView

Filter table object

Wed, 07 Sep 2011 10:07:53 GMT

hi,

I have a table with products in it. A product has a categorie.

I want to have table objects in 4 tabs with the following filters:

Tab1: all cat

Tab2: cat1

Tab3: cat2

Tab4: cat3

I can't find an option in properties to filter the table.

So how can i filter a table object ?

Kind regards,

ThijsJan

Filter table object

swuehl — Wed, 07 Sep 2011 11:49:48 GMT

Hi ThijsJan,

so you got a table chart (pivot or straight table chart) with dimension product, correct?

For a table chart, you could use a calculated dimension (add calculated dimension in dimension tab of chart properties), like

=if( categorie = 'cat1', product)

You could create 4 table charts, 3 with calculated dimension like above (replacing cat1 with cat2, cat3), one with a plain dimension product (for all categories).

Then you have four tables, 3 of them filtered by category. You could then use a container object to include these 4 tables, having tabs to switch between the filtered objects.

Just one idea of how you could maybe achieve what you want,

Stefan

Filter table object

Wed, 07 Sep 2011 11:54:38 GMT

Most probably for tabs 2-4 you should use expression with set analysis.

For example

Tab2:

=sum({$<Category={"Cat1"}>} Amount)

Set analysis expressions are very well described in QlikView help.

Filter table object

Wed, 07 Sep 2011 11:55:57 GMT

Hi,

Thanks for the reply.

I don't have a table chart, I have a table object.

And when I try to do a table chart (pivot or straight) it seems I need an expression otherwise it doens't work. But i have nothing to sum or count.

Filter table object

swuehl — Wed, 07 Sep 2011 12:00:19 GMT

Just for now, you could add a plain

=product

as expression in a straight table, or

, doesn't really matter because then you could hide the expression in a straight table (using presentation tab, upper left corner).

Re: Filter table object

Wed, 07 Sep 2011 12:05:50 GMT

You can try this expression

=sum({$<Category={"Cat1"}>} 1)

and hide the column as suggested by swuehl

Filter table object

Wed, 07 Sep 2011 12:09:51 GMT

Hi,

Thanks it worked.

Kind regards,

ThijsJan

Filter table object

swuehl — Wed, 07 Sep 2011 13:27:21 GMT

That's good to hear!

Just to clarify, you would either need a calculated dimension on tables 2-4 or the set expression, not both at the same time.

Dmitry's solution should be better performing, though.

Have fun,

Stefan