topic Re: Filtering Tablebox for specific jobtitles in QlikView

Filtering Tablebox for specific jobtitles

Tue, 13 Jan 2015 14:58:32 GMT

So I have a tablebox i've created that has numerous different things in it including names, phone numbers and jobtitle.

If i want to have specific jobtitles only showing, not only if i click it, but at all times, how do i go about doing this?

I started with trying to make an matching expression within the title and an aggregate but im still not able to do this?

What im trying to say is that if i have for example: Server, Chef, Waiter i want my box to only (at all times) show the Waiters.

jerem1234 — Tue, 13 Jan 2015 15:26:35 GMT

You can use a straight table and not tablebox.

Use set analysis like:

sum({<Job = {'Waiter'}>}Sales)

The set analysis should reduce your table to only show waiters

or if you want a calculated dimension, you can do something like:

aggr(only({<Job = {'Waiter'}>}Job), Job)

Then check suppress when value is null.

Hope this helps!

Tue, 13 Jan 2015 16:49:05 GMT

Thank you!