topic Re: Re: Spider Chart - Custom Values in QlikView

Spider Chart - Custom Values

Mon, 10 Feb 2014 13:23:47 GMT

Dear community,

I have one question with the spider (radar) chart. I want to use the spider chart to represent 6 different values.

Those values will represent KPIs and are definied in "Dimensions" tab with the following statement:

ValueList('KPI','KPI2','KPI3','KPI4','KPI5','KPI6')

Now i want to add custom values in the "Expression" tab. How can I do this?

It should be like this:

ValueList(formula KPI1 e.g. sum(Revenues)/Amount of Orders,'KPI2','KPI3','KPI4','KPI5','KPI6')

Any Ideas?

Re: Spider Chart - Custom Values

giakoum — Mon, 10 Feb 2014 13:31:04 GMT

you would need the match function to match the valuelist to an actual field value in the dimensions expression. if you do that, expressions should work without anything special needed.

Re: Spider Chart - Custom Values

maxgro — Mon, 10 Feb 2014 14:24:33 GMT

If I understand your question, your expression should be

if(ValueList('KPI','KPI2','KPI3','KPI4','KPI5','KPI6') = 'KP1', sum(Amount),

if(ValueList('KPI','KPI2','KPI3','KPI4','KPI5','KPI6') = 'KP2', sum(....),

...

if(ValueList('KPI','KPI2','KPI3','KPI4','KPI5','KPI6') = 'KP6', sum(....)

))))))

Re: Re: Spider Chart - Custom Values

Tue, 11 Feb 2014 06:30:53 GMT

Thanks a lot, this was the right expression to solve my problem.

Now I have another question - it is possible to represent those calculated KPIs values in the chart?

I've added a sample file below - the black line represents the KPI values and the red line

represents the benchmark.

Thanks in advance!