topic Re: Pie Chart Display in QlikView

Pie Chart Display

shannoypaul — Fri, 18 Jul 2014 17:14:48 GMT

Hi,

ConsumerType is a field with 4 values High, Medium, Low and Very Low.

I have to consider only 3 i.e High, Medium, Low and display their respective percentages.

Please help me out.

Thanks in advance!

Re: Pie Chart Display

simenkg — Fri, 18 Jul 2014 17:26:57 GMT

If you have ConsumerType as Dimension

and have the expression as

sum(Value) / sum( Total Value)

or
count(ConsumerID) / count(Total ConsumerID)

Now you can pick the ConsumerType from a Listbox and the chart will show the percentages between the selected ConsumerTypes

Re: Pie Chart Display

kaushiknsolanki — Fri, 18 Jul 2014 17:32:00 GMT

HI,

You can write an calculated dimension as below.

=if(ConsumerType = 'Very Low',null(),ConsumerType )

Select "Supress When Value is Null"

Go to Expression and write your expression and click on "Relative"

Also click on "values on Data Point".

Go to "Numbers" tab and click on the expression and select "Show in %"

Regards,

Kaushik Solanki

Re: Pie Chart Display

m_woolf — Fri, 18 Jul 2014 17:32:56 GMT

Try a calculated dimension something like:

if(ConsumerType<>'Very Low',ConsumerType)

Re: Pie Chart Display

simenkg — Fri, 18 Jul 2014 17:40:18 GMT

I'll add that if you somehow want to lock the choices you do it by using Set analysis.

if you dont want to show Very Low, the expressions become

Count({$<ConsumerType-={'Very Low'}>} ConsumerID) / Count(total {$<ConsumerType-={'Very Low'}>} ConsumerID)

or if you like this syntax better:
Count({$<ConsumerType={'High','Medium','Low'}>} ConsumerID) / Count(total {$<ConsumerType={'High','Medium','Low'}>} ConsumerID)