Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhu0505
Specialist
Specialist

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



1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

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

View solution in original post

10 Replies
Not applicable

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

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
Specialist
Specialist
Author

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

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
Partner - Master III
Partner - Master III

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
Specialist
Specialist
Author

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
Specialist
Specialist
Author

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
Partner - Master III
Partner - Master III

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
Partner - Master III
Partner - Master III

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