topic Radar Chart in QlikView

Radar Chart

prabhu0505 — Tue, 13 Apr 2010 08:02:22 GMT

Hi All,

I would like to create a radar chart with the following source as input. The output that I expect is that the energy, health, height and refresh should be axes or dimensions and product should be the expression.

load * inline [
product,energy,health,height,refresh
boost,23,21,45,54
complan,54,43,44,23
liondates,44,66,23,12
slice,32,12,22,66
maaza,65,45,32,44
];

Anybody there?

Thanks

Prabhu

Radar Chart

Tue, 13 Apr 2010 08:22:02 GMT

Hi Prabhu,

Radar charts are a great way to display data by cyclic dimensions, so as per my understand your requirement doesn't suit for radar chart. So let's wait for some other comments.

Regards,

Ravi....

Radar Chart

Or — Tue, 13 Apr 2010 08:58:17 GMT

I can't see any way to do it without changing the data around - this simply isn't how a radar chart works in QV (or in general). For smaller volumes of data (e.g. your four lines in this example), you can achieve this data by using the Transpose() filter option on your data, ending up with the following:

The downside, of course, is that you will need to insert every product name as an expression to get this to work (the four numeric columns are dimensions). If you intend to have a large number of products, you will need to set up some sort of lookup or macro to find out which ones are selected and input those into your expressions.

Radar Chart

prabhu0505 — Tue, 13 Apr 2010 10:28:35 GMT

Hi Shoham,

Can you be bit more detailed in some of the areas like

1. changing the data around

2. product name as expression

Thanks for your interest.

Radar Chart

Or — Tue, 13 Apr 2010 11:36:23 GMT

Put your data in an Excel or text file, use the wizard to get to it, and enable the transformation step. Under "Rotate", select "Transpose". This should flip the data around - each product will become a column rather than a row.

Radar Chart

lironbaram — Tue, 13 Apr 2010 11:44:18 GMT

hei look at the attach example

what i did is adding a step to the script ,

the new step is doing a croos table load on the original table.

i hope the example helps you

Radar Chart

prabhu0505 — Tue, 13 Apr 2010 11:53:33 GMT

Yes Shoham you are right, that is where I got struck. As you know in reality it is not possible to add the fields when a new product is introduced in the market, I'm looking for a solution which may have hands-on the design of the table(guess) to satisfy this.

Even other views are welcome

Thanks,

Prabhu

Radar Chart

prabhu0505 — Tue, 13 Apr 2010 12:00:45 GMT

Hi RoiUser,

Thanks for your interest.

I'm using Personal edition so I can't open the example that you have uploaded, so can you please explain it and copy paste it here in this thread

Radar Chart

lironbaram — Tue, 13 Apr 2010 12:04:02 GMT

hei attach is a text file with the new script after that build the radar chart like this first dimension : Prod_Article second dimension: Product

Radar Chart

lironbaram — Tue, 13 Apr 2010 12:08:00 GMT

hei attach is text file with the new script after the reload build a new radar chart like this

1 dim : Prod_article .

2 dim: Product

Exp: sum(Prod_Data)

hope its helps

Radar Chart

prabhu0505 — Tue, 13 Apr 2010 12:42:20 GMT

Hi RoiUser,

It is working.

Thanks for your timely help

Prabhu