topic Re: Filter a table box based on a key field in QlikView

Filter a table box based on a key field

Wed, 09 Sep 2015 19:23:16 GMT

I am attaching a quick example similar to what I am trying to do.

I have calls with a CallID. There may be 1 or many lines for a call. Calls have segments (# order) and categories.

If I filter on a certain category, the chart in the attached example works as expected. I only see the line with that category.

However, what I want to see is all the lines for call where the category exists on any line. For example, I have one call that was conferenced. It is CallId 11111. If I click "Conference" in the categories, I see that one line from that one call in the "Works" chart as expected. What I want to do is build a table box that shows all 3 lines for the call.

Is this possible?

Thanks!!!

Re: Filter a table box based on a key field

MK_QSL — Wed, 09 Sep 2015 19:49:46 GMT

Create a Straight Table

Dimension

CallID

Re: Filter a table box based on a key field

Thu, 10 Sep 2015 14:07:22 GMT

Thank you so much! Worked perfectly. I really appreciate it.

Re: Filter a table box based on a key field

MK_QSL — Thu, 10 Sep 2015 14:36:49 GMT

Kindly close the thread by selecting appropriate answer.