Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can try this expression
=sum({$<Category={"Cat1"}>} 1)
and hide the column as suggested by swuehl
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
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.
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.
Just for now, you could add a plain
=product
as expression in a straight table, or
=1
, doesn't really matter because then you could hide the expression in a straight table (using presentation tab, upper left corner).
You can try this expression
=sum({$<Category={"Cat1"}>} 1)
and hide the column as suggested by swuehl
Hi,
Thanks it worked.
Kind regards,
ThijsJan
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