Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

prabhu0505
Valued Contributor

Radar Chart

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



Tags (2)
1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

Radar Chart

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

10 Replies
Not applicable

Radar Chart

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....

Or
Valued Contributor II

Radar Chart

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.

prabhu0505
Valued Contributor

Radar Chart

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.

Or
Valued Contributor II

Radar Chart

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.

lironbaram
Honored Contributor II

Radar Chart

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

prabhu0505
Valued Contributor

Radar Chart

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

prabhu0505
Valued Contributor

Radar Chart

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

lironbaram
Honored Contributor II

Radar Chart

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
lironbaram
Honored Contributor II

Radar Chart

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