Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
dinicholls
Contributor II

Set Analysis and Identifier Confusion!

Hi All,

I'm experimenting with my charts in my app.

I want to produce a chart that shows the number of calls overall, and then included on the chart the number of calls but by the selected agent.

The problem is, I'm getting really confused as to how to use the set analysis.

In my chart I have my dimension as 'Agent', and my expression as 'Count(DISTINCT([Contact ID]))', giving me the number of calls by agent.

How do I use set analysis, if that's the right tool, so that when an agent is selected, it shows the number of their calls, AND the total count of the rest of the calls as one. So, if using a pie chart, and the agent had called 25 calls, and overall, including the agents calls there were 100 placed, you would see the pie chart with a quarter showing for the agent, 25% of the calls made, and 75% of the pie chart as all the remaining calls made.

Does that make sense?!

Thanks

Di

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Set Analysis and Identifier Confusion!

Okey Dokey, see what your after now, Check out the new version

View solution in original post

5 Replies
Highlighted
Partner
Partner

Re: Set Analysis and Identifier Confusion!

Hi Diane,

an easy way would be to add 'Text in chart' on the presentation tab, with a expression like

='Total Calls ' & Count(Total(ContactID))

Then use CTRL and SHIFT keys to resize and move the text to where it's required.

Example attached

Andy

Highlighted
dinicholls
Contributor II

Re: Set Analysis and Identifier Confusion!

Thanks Andy, but that isn't what I need to see.

I've tried this so far, with no luck!

Count({$<Agent=>}DISTINCT([Contact ID]))

It just brings back everyone, when I just one the selected agent's, and a total for the rest.

Have attached a quick jpeg of what I'm trying to get it to look like.

Di

Highlighted
mikecrengland
Contributor III

Re: Set Analysis and Identifier Confusion!

Hi Diane,

You can fake it a little by messing with the colors. Take a look at my post:

Fortune Cookie BI: Twisting the knife in a useful pie chart

It will show you how to make your pie chart two colors, based on the selection.

mike

Highlighted
Partner
Partner

Re: Set Analysis and Identifier Confusion!

Okey Dokey, see what your after now, Check out the new version

View solution in original post

Highlighted
Partner
Partner

Re: Set Analysis and Identifier Confusion!

Excellent! Glad it did the trick!