
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Radar chart - data
Hi
I'm finding it difficult to plot a Radar Chart using the following extension: Qlik Branch. I suspect it has something to due with the way my data is structured.
Here is my data:
CompanyID | CompanyName | Revenue | GrossProfit | Balance Sheet | EBIT | Equity |
---|---|---|---|---|---|---|
1 | Copenhagen Beer A/S | 100$ | 77$ | 250$ | 177$ | 500$ |
2 | Dan Cars | 150$ | -13$ | 144$ | 133$ | 250$ |
3 | BioPharma Inc | 77$ | 5$ | 102$ | 55$ | 300$ |
4 | Sovino A/S | 23$ | 44$ | 88$ | 62$ | 425$ |
Then I use a value function to create a list including the company, the average, top 50 and top 10.
=ValueList('Companye','Average','Top 50', 'Top 10')
Then I want to create a Radar Chart where the two dimensions are the Key Figures (Revenue, GrossProfit, Balance Sheet, EBIT and Equity) and the ValueList, and the measure are Dollars.
Does anyone have an idea how to do this?
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
one parenthesis to remove I think :
if(ValueList('A','B') = 'A',
if(ValueList('V1','V2','V3','V4') = 'V1', sum(V1),
if(ValueList('V1','V2','V3','V4') = 'V2',sum(V2),
if(ValueList('V1','V2','V3','V4') = 'V3',sum(V3),
if(ValueList('V1','V2','V3','V4') = 'V4',sum(V4) )
))))


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
with this radar you'll have two value list :
valuelist('Revenue','gross profit' .....) too
and in expression :
if( ValueList('Companye','Average','Top 50', 'Top 10') = 'Company',
if(valuelist('Revenue','gross profit' .....) = 'revenue', sum(revenue),
and so on
regards

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Olivier,
Don't think I quite get you.
Can you please eloborate further?
Kind regards


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
here is the begnning :
as Dimensions :
KPI : ValueList('Revenue','Profit')
TypeKPI : ValueList('Company','Average')
as expression :
if(ValueList('Company','Average') = 'Company',
if(ValueList('Revenue','Profit') = 'Revenue', sum(revenue),
if(ValueList('Revenue','Profit') = 'Profit',sum(profit))
),
if(ValueList('Company','Average') = 'Average',
if(ValueList('Revenue','Profit') = 'Revenue', avg(revenue),
if(ValueList('Revenue','Profit') = 'Profit',avg(profit))
))
)
I let you complete for all values of list 😉

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Olivier,
Can you tell me what I'm doing wrong?
---------------------------------------------------------------------------------------------------------------------------------------------------
DIM1: =ValueList('A','B')
DIM2: =ValueList('V1','V2','V3','V4')
Expression:
if(ValueList('A','B') = 'A',
if(ValueList('V1','V2','V3','V4') = 'V1', sum(V1),
if(ValueList('V1','V2','V3','V4') = 'V2',sum(V2)),
if(ValueList('V1','V2','V3','V4') = 'V3',sum(V3)),
if(ValueList('V1','V2','V3','V4') = 'V4',sum(V4))
),
if(ValueList('A','B') = 'B',
if(ValueList('V1','V2','V3','V4') = 'V1', sum(V1),
if(ValueList('V1','V2','V3','V4') = 'V2',avg(V2)),
if(ValueList('V1','V2','V3','V4') = 'V3',avg(V3)),
if(ValueList('V1','V2','V3','V4') = 'V4',avg(V4)),
))
)
------------------------------------------------------------------------------------------------------------------------------------------------------
I get this error:
"Error in expression: If takes 2-3 parameters"
Kind regards


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
one parenthesis to remove I think :
if(ValueList('A','B') = 'A',
if(ValueList('V1','V2','V3','V4') = 'V1', sum(V1),
if(ValueList('V1','V2','V3','V4') = 'V2',sum(V2),
if(ValueList('V1','V2','V3','V4') = 'V3',sum(V3),
if(ValueList('V1','V2','V3','V4') = 'V4',sum(V4) )
))))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You were right, of course 🙂 Thank you!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey again,
I'm trying to add a third category to DIM1.
if(ValueList('A','B,'C') = 'A',
if(ValueList('V1','V2','V3','V4') = 'V1', sum(V1),
if(ValueList('V1','V2','V3','V4')= 'V2',sum(V2),
if(ValueList('V1','V2','V3','V4') = 'V3',sum(V3),
if(ValueList('V1','V2','V3','V4') = 'V4',sum(V4))
))),
if(ValueList('A','B','C') = 'B',
if(ValueList('V1','V2','V3','V4') = 'V1', avg(V1),
if(ValueList('V1','V2','V3','V4') = 'V2',avg(V2),
if(ValueList('V1','V2','V3','V4') = 'V3',avg(V3),
if(ValueList('V1','V2','V3','V4') = 'V4',avg(V4))
)))),
if(ValueList('A','B','C') = 'C',
if(ValueList('V1','V2','V3','V4') = 'V1', avg(V1)*2,
if(ValueList('V1','V2','V3','V4') = 'V2',avg(V2)*2,
if(ValueList('V1','V2','V3','V4') = 'V3',avg(V3)*2,
if(ValueList('V1','V2','V3','V4') = 'V4',avg(V4)*2
))
))))
But I get the same error:
Error in expression: If takes 2-3 parameters
Is it still one parenthesis to remove?
Thanks in advance.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I thing so
here :
if(ValueList('A','B','C') = 'B',
if(ValueList('V1','V2','V3','V4') = 'V1', avg(V1),
if(ValueList('V1','V2','V3','V4') = 'V2',avg(V2),
if(ValueList('V1','V2','V3','V4') = 'V3',avg(V3),
if(ValueList('V1','V2','V3','V4') = 'V4',avg(V4))
)))),
in the editor, click on left parenthesis (higlighted in yellow),
then you'll see where it ends

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi again,
Now I don't get the error anymore, but no values are shown?
if(ValueList('Regnskabsaflæggende_virksomeds_navn','Gennemsnit','Top 10') =
if(ValueList('Regnskabsaflæggende_virksomeds_navn','Gennemsnit','Top 10') = 'Regnskabsaflæggende_virksomeds_navn',
if(ValueList('Årets resultat','Ordinært resultat før skat','Likvide beholdninger','Bruttofortjeneste') = 'Årets resultat', sum([Årets resultat]),
if(ValueList('Årets resultat','Ordinært resultat før skat','Likvide beholdninger','Bruttofortjeneste')= 'Ordinært resultat før skat',sum([Ordinært resultat før skat]),
if(ValueList('Årets resultat','Ordinært resultat før skat','Likvide beholdninger','Bruttofortjeneste') = 'Likvide beholdninger',sum([Likvide beholdninger]),
if(ValueList('Årets resultat','Ordinært resultat før skat','Likvide beholdninger','Bruttofortjeneste') = 'Bruttofortjeneste',sum(Bruttofortjeneste))
))),
if(ValueList('Regnskabsaflæggende_virksomeds_navn','Gennemsnit','Top 10') = 'Gennemsnit',
if(ValueList('Årets resultat','Ordinært resultat før skat','Likvide beholdninger','Bruttofortjeneste') = 'Årets resultat', avg([Årets resultat]),
if(ValueList('Årets resultat','Ordinært resultat før skat','Likvide beholdninger','Bruttofortjeneste') = 'Ordinært resultat før skat',avg([Ordinært resultat før skat]),
if(ValueList('Årets resultat','Ordinært resultat før skat','Likvide beholdninger','Bruttofortjeneste') = 'Likvide beholdninger',avg([Likvide beholdninger]),
if(ValueList('Årets resultat','Ordinært resultat før skat','Likvide beholdninger','Bruttofortjeneste') = 'Bruttofortjeneste',avg(Bruttofortjeneste)),
))),
if(ValueList('Regnskabsaflæggende_virksomeds_navn','Gennemsnit','Top 10') = 'Top 10',
if(ValueList('Årets resultat','Ordinært resultat før skat','Likvide beholdninger','Bruttofortjeneste') = 'Årets resultat', (avg([Årets resultat])*2),
if(ValueList('Årets resultat','Ordinært resultat før skat','Likvide beholdninger','Bruttofortjeneste') = 'Ordinært resultat før skat',(avg([Ordinært resultat før skat])*2),
if(ValueList('Årets resultat','Ordinært resultat før skat','Likvide beholdninger','Bruttofortjeneste') = 'Likvide beholdninger',(avg([Likvide beholdninger])*2),
if(ValueList('Årets resultat','Ordinært resultat før skat','Likvide beholdninger','Bruttofortjeneste') = 'Bruttofortjeneste',(avg(Bruttofortjeneste)*2),
))
)))))
