Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
motzfeldt01
Partner
Partner

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:

CompanyIDCompanyNameRevenueGrossProfitBalance SheetEBITEquity
1Copenhagen Beer A/S100$77$250$177$500$
2Dan Cars150$-13$144$133$250$
3BioPharma Inc77$5$102$55$300$
4Sovino A/S23$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?

1 Solution

Accepted Solutions
ogautier62
Specialist II
Specialist II

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)  )

))))

View solution in original post

9 Replies
ogautier62
Specialist II
Specialist II

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

motzfeldt01
Partner
Partner
Author

Hi Olivier,

Don't think I quite get you.

Can you please eloborate further?

Kind regards

ogautier62
Specialist II
Specialist II

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 😉

    

motzfeldt01
Partner
Partner
Author

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

ogautier62
Specialist II
Specialist II

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)  )

))))

motzfeldt01
Partner
Partner
Author

You were right, of course 🙂 Thank you!

motzfeldt01
Partner
Partner
Author

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.

ogautier62
Specialist II
Specialist II

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







motzfeldt01
Partner
Partner
Author

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),

      

        ))


      )))))