topic Compass in radar chart in QlikView

Compass in radar chart

Tue, 17 May 2011 13:11:21 GMT

Hi all

I would like to make a radar chart in which I would to display the electricity production of wind turbine per wind direction.

I believe the radar chart is the best option for that: I'll apply the class function to my wind direction variable, and plot my production against this.

Two issues though (see images below:

- Image 1: the data point for 0-30 degree range is on top, whereas I would like it to where the 30-60 degree point is now.

- Image 2: if I filter on one given day in the year, the wind does not do a full 360 tour during that day, so I see only those point where the wind has actually come from that day. Apparently, setting the dimension axis scale does not solve this.

Any thoughts on how to resolve this?

Image 1

Image 2

Compass in radar chart

pat_agen — Tue, 17 May 2011 13:38:35 GMT

hi,

one way of doing it could be as follows:

building a Master Wind Direction table to which you connect your wind variable.

Create it in your script by doing something like the following:

masterWindDirectiontmp:

load distinct WindDirection // thislinks to your table with production and wind dircetion

resident PreviouslyLoadedProductionData;

masterWindDirection:

load WindDirection,

put your class function here as WindDirectionGroup // this creates your 12 groups you want on the radar chart

resident masterWindDirectiontmp;

drop table

masterWindDirectiontmp;

now you attach to the previos table a 12 row table which gives you the sorting you are looking for

This table would have its 12 rows as you achieved with using your class function, make sure the WindDirectionGroup has the sames names and they will link up

masterWindDirectionSortOrder:

load * inline

[

WindDirectionGroup, WindDirectionGroupSortOrder

330 t 360, 1

0 to 30, 2

etc

etc.

];

Now in your radar chart use the WindDirectionGroup field as dimension, sum the production from your initial table, on the sort tab select "Expression" and then select the WindDirectionGroupSortOrder in th expression box, on the presentation tab make sure "Supress ZERo-values" and " suppress missing" are not ticked.

hope this helps

Compass in radar chart

chriscammers — Tue, 17 May 2011 13:56:57 GMT

I know your requirement is to produce a radar chart but I think the intention behind the chart is to compare production at the different points on the compas. I agree that it is logical to display it as a radar but I can't help but feel that a bar chart would be better to compare the quantity at each direction.

Realizing what effect you are trying to achieve I have to wonder what would happen to your radar chart if the user were to filter out directions greater than 180, the radar chart would still display a circle but you'd have only half a circle worth of compass points.

Just some things to think about from a vizualization perspective.

Thanks

Chris