topic Re: Radar Chart - how to get it right? in QlikView

Radar Chart - how to get it right?

Tue, 08 Oct 2013 11:42:23 GMT

Hi Guys.

This is the situation:

I want to create a radar chart that will have as a Dimenstion all numbers from 1 up until =count({1} distinct [Account ID])) (1 to 87 in my example).

I have many Expressions, each corresponds to a different field, and I need to count the [Account ID] that meets the current slection.

For example:

1. I have 30 account that meet condition 1, and I want a dot on a 1..87 Dimension

2. I have 45 account that meet condition 2, and I want a dot on another 1..87 Dimension

3. I have 12 account that meet condition 3, and I want a dot on another 1..87 Dimension

Each of these dots should be on a different 1..87 Bar, hence creating the Radar. The conditions are calculated by using Set Analysis - no problem there.

The problems are:

1. when I use =count({1} distinct [Account ID])) as a Dimension, I get "Error in calculated Dimension". So I thought it might require a range as a Dimension so I tried this: =ValueLoop (1, count({1} distinct [Account ID]))). Same result.

2. All Expressions are calculated on the same Dimension. See attached.

Thanks for your help!

Re: Radar Chart - how to get it right?

Wed, 09 Oct 2013 07:28:30 GMT

No one?

Re: Radar Chart - how to get it right?

bbi_mba_76 — Wed, 09 Oct 2013 07:38:10 GMT

Hi,

you could look at this example of radar chartRadar Chart

With one dimension you could have (F2, F3, F4 are flags)

Re: Radar Chart - how to get it right?

Wed, 09 Oct 2013 08:43:25 GMT

Micherel thanks for your answer.

Unfortunately, that is not what I am looking for.

If I go your way, I have to modify my CSV segnificantly, and I won't have the dynamic data change of Qlik.

This is what I am looking for (there should be only one, Blue or Red Dimension):

Please note, I have no problem in calculating the dot, I have a problem acheiving this representation.

Re: Radar Chart - how to get it right?

bbi_mba_76 — Wed, 09 Oct 2013 09:53:07 GMT

I think you have to set your Parameter1 as dimension and the count as expression.

In this case I have Sales as dimension and the count for the expression, the radar is showing the number of account having 1,2,3 as Sales

Re: Radar Chart - how to get it right?

Wed, 09 Oct 2013 10:55:34 GMT

Michele thanks!

I'm almost there, you pointed me in the right direction.

I have created a list in my CSV for the Dimensions.

The problem that I have now is that I need to tie each dimension to one and only one expression. As you can see in the attached, I need the blue line to be only a dot on the "CMDB" dimension, and the red line to be a dot on the Escalation dimension. Any idea how it's possible?

Re: Radar Chart - how to get it right?

bbi_mba_76 — Wed, 09 Oct 2013 11:02:20 GMT

Maybe you could add an if in your expressions

for the blue line if(<Dimension>='CMDB', count(...))

and for the red if(<Dimension>='Escalation', count(...))

Re: Radar Chart - how to get it right?

Wed, 09 Oct 2013 11:31:09 GMT

Yes! Michele thank you so much.

I got what I wanted.

I guess there's no way to connect the dots as they represent different expressions...?

Re: Radar Chart - how to get it right?

bbi_mba_76 — Wed, 09 Oct 2013 11:59:39 GMT

Maybe if you have only one expression with all the nested if...