topic Re: Radar chart dimension location in QlikView

Radar chart dimension location

Anonymous — Mon, 24 Mar 2014 17:57:43 GMT

Hi guys,

I have a radar chart with labels. Is it possible to change orientation of labels? Please see below image.

Navigation and Interactivity should be vertically.

Thanks,

Re: Radar chart dimension location

maxgro — Mon, 24 Mar 2014 18:31:53 GMT

I haven't your data but it should work the same way

RESULT

in sort tab define the order: change Dim1 to your dimension and B C D A to your value (Motivation ,...)

Re: Radar chart dimension location

Luis_Cortizo — Mon, 24 Mar 2014 18:32:43 GMT

You can modify the sort order of the Dimension on the Sort tab of the chart properties; to accomplish what you want to do it would require an if statement on the expression input box to sort the values according to some "logic".

However the if statement can be quite a resource consuming calculation so I would order the chart on the script.

Let's say that the Dimension that you are using is called: MyDimension.

At the beginning of the script, you can create an inline table like:

DimOrder:

LOAD * INLINE [

MyDimension

Navigation

Motivation

Interactivity

Content

];

And at the end of the script, you can drop that table:

Drop Table DimOrder;

All that is needed now is uncheck everything on the sort tab of the chart and check the Load Order option. It will order the chart on the same order that the information was loaded (on the first axis Navigation, after that Motivation, after that Interactivity and finally Content).

Easy to do, very light on resources and easy to maintain

Hope it helps.

Best regards.

Re: Radar chart dimension location

Anonymous — Mon, 24 Mar 2014 18:36:30 GMT

interesting, but i thought the OP wanted to change the orientation of the labels...i understood as display the label (Navigation, etc.) vertically but not on the veritcal axes.

...i don't think you can change the orientation of the labels the way OP described it but if he meant rearrange the order of the dimensions so that two specific ones are shown on vertical axes, the other two replies here are the way to go.

Re: Radar chart dimension location

maxgro — Mon, 24 Mar 2014 18:39:09 GMT

if you want to change label from horizontal to vertical I think isn'tpossible in radar

workaround: in presentation tab add 2 text in chart and change angle (degrees) to meet your requirement

Re: Radar chart dimension location

Anonymous — Mon, 24 Mar 2014 18:39:50 GMT

I can make sort. I'm limited in size, I need for Navigation and Interactivity to change orientation from horizontal to vertical.

Re: Radar chart dimension location

Anonymous — Mon, 24 Mar 2014 18:42:47 GMT

i would use text boxes like Massimo described to achieve your requirement. of course, it will not work if you have any of the four dimensions selected and order is different!

Re: Radar chart dimension location

Anonymous — Mon, 24 Mar 2014 18:42:49 GMT

I thought to uncheck labels for dimension and add 4 text objects.

Re: Radar chart dimension location

Luis_Cortizo — Mon, 24 Mar 2014 18:42:50 GMT

Sorry I didn't understand the question... I can't think of any way of rearranging the labels the way you want to besides the recommendation from Massimo.

Re: Radar chart dimension location

Luis_Cortizo — Mon, 24 Mar 2014 18:45:35 GMT

I would the same thing as Massimo and you, but of course then the chart needs to be static (a simple {1} with Set Analysis). Otherwise a selection will modify it and the labels wouldn't make sense.

Re: Radar chart dimension location

Anonymous — Mon, 24 Mar 2014 18:58:21 GMT

I'd like to make like this. (ignore color background)

Re: Radar chart dimension location

maxgro — Mon, 24 Mar 2014 19:02:19 GMT

I suppose you have to play with flag in dim tab

suppress when value is null (check)

show all values (check)

and flag in presentation tab

suppress zero (uncheck)

suppress missing (check)

so your dims doesn't change with selections

Re: Radar chart dimension location

Anonymous — Mon, 24 Mar 2014 19:17:52 GMT

that is not possible directly. but can be achieved with text boxes...

In dimension tab,

1. uncheck display labels

2. create four text boxes, one for each label.

3. place the text boxes at the correct locations.

4. of course, change the orientation of text in the two text boxes you need to 90 degree so text is displayed vertically.

all is fine...but when a user selects one or more of the dimensions, your labels will not match the chart anymore. to avoid this, you may have to create a state and put this chart in a separate state or do something else.

Re: Radar chart dimension location

maxgro — Mon, 24 Mar 2014 19:20:04 GMT

Re: Radar chart dimension location

Anonymous — Mon, 24 Mar 2014 19:24:45 GMT

that is a very clever way of achieving the requirement Massimo...there are so many creative ways things can be done in QV...it continues to amaze me! thanks for the solution. learned something!

Re: Radar chart dimension location

Anonymous — Mon, 24 Mar 2014 19:39:57 GMT

I have questions:

1. replicated the same chart. but when I select any of tag from Dim1, in the chart shows only my selected tag.

(suppress when value is null,show all Value checked)

2. why I can't see actual labels in your chart?

Thanks,

Re: Radar chart dimension location

maxgro — Mon, 24 Mar 2014 19:48:16 GMT

axis tab --> font --> color --> transparent

dim tab --> show legend shuold be checked

did you uncheck suppress zero values in presentation tab?

Re: Radar chart dimension location

Anonymous — Mon, 24 Mar 2014 19:50:24 GMT

Thanks. It's exactly want I needed.

Re: Radar chart dimension location

Anonymous — Mon, 24 Mar 2014 19:59:23 GMT

When you make axis tab --> font --> color --> transparent, there is no data value .:(

Re: Re: Radar chart dimension location

maxgro — Mon, 24 Mar 2014 20:37:50 GMT

some changes but popup is gone