0 Replies Latest reply: Aug 6, 2013 12:11 PM by Philip Albrecht RSS

    Radar Chart Dimensions

      Dear all,

       

      I have a question concerning definition of axes in a radar chart. I've got 5 categories I want to display as axes. Furthermore I've got lots of data (e.g. companies) for which I have specific values for each category.

       

      By now I structured my data the following way to build the radar chart.

       

      Used Dimensions for the Chart are: Category and Entity

      Used Expression is: only (value)

       

      Example:

       

      Entity               Category               Value

      A                     Dimension 1               1

      A                     Dimension 2               3

      A                     Dimension 3               5

      A                     Dimension 4               2

      A                     Dimension 5               3

       

      C                     Dimension 1               2

      C                     Dimension 2               5

      C                     Dimension 3               5

      C                     Dimension 4               3

      C                     Dimension 5               4

       

       

      Screenshot_Diagramm_QlikView.jpg

       

       

      Is it possible to build a radar chart like the one above, without multiple lines of categories for every entity, with a data structure like the one below?

       

      Entity               Dimension 1          Dimension 2           Dimension 3    ...

      A                         1                                 3                              5           ...

      B                         ...                               ...                              ....        ...

      C                         2                                 5                              5           ...  

       

       

      Hope someone can solve my problem....