topic Re: Pie Chart in QlikView

Pie Chart

knightwriter — Thu, 17 Apr 2014 11:16:54 GMT

Hi All,

I want to create a pie chart with only certain values (peoples names) in a pie chart.

In my excel column I have a long list of names but only want to show 4 or 5 of these names in my pie chart. Any ideas how to create this?

As you probably know pie charts cant look awful with too much infomartion!

Re: Pie Chart

its_anandrjs — Thu, 17 Apr 2014 11:36:55 GMT

Add calculated dimension for that like

=If([peoples names]= 'Name1','Name1',

If([peoples names]= 'Name2','Name2',

If([peoples names]= 'Name3','Name3')))

And click on Suppress When Value Null

Re: Pie Chart

its_anandrjs — Thu, 17 Apr 2014 11:39:21 GMT

You can use SET analysis for this also which is better way of doing pie chart calculation

Dimention :- [peoples names]

Expression :- Sum( {<[peoples names] = {'Name1','Name2','Name3','Name4'}>} Values )

Re: Pie Chart

Thu, 17 Apr 2014 11:49:16 GMT

you can use dimension limit tab in chart properties

Re: Pie Chart

MK_QSL — Thu, 17 Apr 2014 12:07:19 GMT

Create a PIE Chart

USING a Calculated Dimension

Dimension

Use calculated Dimension as below

=IF(Match([People Name],'Name1', 'Name2', 'Name3', 'Name4'),[People Name])

Tick Suppress When Value is NULL

Expression

As per your requirements

USING a Set Analysis (Just an Example)

Dimension

[Customer Name]

Expression

SUM({$<[Customer Name] = {'Name1','Name2','Name3'}>}Sales)

Performance wise, set analysis is better compare to Calculated Dimension

Hope this helps...

Re: Pie Chart

Colin-Albert — Thu, 17 Apr 2014 12:11:13 GMT

Use dimension limits

Re: Pie Chart

knightwriter — Thu, 17 Apr 2014 13:05:08 GMT

@its.anandrjs thanks for this, very much appreciated.

If one of the names is O'Malley for example, how do I work this into my equation as the ' is causing an error?

Thank you to the other people who have also responded.

Re: Pie Chart

MK_QSL — Thu, 17 Apr 2014 15:49:43 GMT

Something like below

SUM({<Name = {"O'Malley","O'Connor"}>}Sales)

Re: Pie Chart

its_anandrjs — Thu, 17 Apr 2014 16:49:08 GMT

Ok You can write like this for the

Dimension :-

= If([peoples names]='Name3','Name3',

If([peoples names]='O'&Chr(39)&'Malley','O'&Chr(39)&'Malley',)) // For O'Malley type of string

If you use SET analysis then you can do like

Dimension :- [peoples names]

Expression :- SUM( {< [peoples names] = {"O'Malley"} >} SaleValue )