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 [
Solved! Go to Solution.
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.
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.
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.
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 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