topic Re: Radar Graph Help in QlikView

Radar Graph Help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys

I have three expressions that each represent an individual score.

Can someone advise me as to how I put them on to a radar graph for comparison please?

I have had a go and it ends up looking like my 2 year old has colored in a circle!

Thanks,

Gareth

Re: Radar Graph Help

oscar_ortiz — Tue, 29 Aug 2017 13:17:22 GMT

Gareth,

Can you provide some sample data and what expected results should look like?

Thanks

Oscar

Re: Radar Graph Help

Anonymous — Tue, 29 Aug 2017 13:55:11 GMT

Hi Oscar,

I've managed to create the radar graph eventually, fell lucky!

However, any ideas on how I'd color the area inside the data points depending on the score? Almost like a heat map

So for instance, on the attached, if a score is <79% is red, =79% and <85% is amber and =>85% green.

Thanks,

Gareth

Re: Radar Graph Help

oscar_ortiz — Tue, 29 Aug 2017 14:37:01 GMT

Gareth,

You can have a look at what I've done here.

I've added a background color to the chart expression by expanding the expression. You will need to modify that to fit your needs, but this should give you a good starting point.

I've also modified the style of the chart.

Finally, I've changed your script slightly to do a cross table load of your data. The reason for this was to allow for a dimension to go along with a simple expression.

Have a look and let me know your thoughts.

Good luck!

Oscar

Re: Radar Graph Help

Anonymous — Tue, 29 Aug 2017 15:05:04 GMT

Thanks Oscar,

I understand the background chart color, but not sure what you mean by expanding the expression.

Likewise, I'm not sure what you mean by "Finally, I've changed your script slightly to do a cross table load of your data. The reason for this was to allow for a dimension to go along with a simple expression."

I do now have the below, which is progress!

Thanks,

Gareth

Re: Radar Graph Help

oscar_ortiz — Tue, 29 Aug 2017 15:09:15 GMT

Gareth,

Expanding the expression was simply clicking the plus sign to view the expression properties or expand the expression. That's simply getting to the background chart color.

I guess it would have been helpful to send the actual app I created.

Have a look at the script here, this is where I did the cross table load.

Good luck!

Oscar

Re: Radar Graph Help

Anonymous — Tue, 29 Aug 2017 15:16:24 GMT

Thanks Oscar,

That's brill.

Thanks again,

Gareth