topic Re: Sections in pie chart in QlikView

Sections in pie chart

rsdhavle — Mon, 14 Apr 2014 13:52:18 GMT

I have no. of clients and their revenue percentages i want to categorize clients who has revenue between A to B values, B to C values and show it into pie chart. What is the was. What would be dimension in this case?

Re: Sections in pie chart

its_anandrjs — Mon, 14 Apr 2014 13:58:36 GMT

You can use calculated dimension or you can make the bucket for this.

Re: Sections in pie chart

rsdhavle — Mon, 14 Apr 2014 14:00:13 GMT

Can you give a sample expression?

Re: Sections in pie chart

Mon, 14 Apr 2014 14:04:46 GMT

Create intervalmatch table.

The intervalls are your dimension and the count of customers is your expression

Re: Sections in pie chart

Mon, 14 Apr 2014 14:06:12 GMT

type this in calculated dimension or in your script (better solution) and you will have your categories :

if(revenue>2k,'litlle client',if(revenue>50k,'middle client',if(revenue>100k,'big client')))

Re: Sections in pie chart

its_anandrjs — Mon, 14 Apr 2014 14:07:02 GMT

Sorry i update new table now check

Look at simple example you have a table where there is client name, Revenue %

Tab1:

LOAD * Inline

[

Client,Revenue%

A,20

B,30

C,10

D,50

E,50

F,40

G,20

H,70

I,55

];

Data:

LOAD *,

if(Revenue% >=10 and Revenue% <=30, 'Between 10-30',

if(Revenue% >=30 and Revenue% <=60, 'Between 30-60',

if(Revenue% >=60 and Revenue% <=90, 'Between 60-90',))) as Category

Resident Tab1;

DROP Table Tab1;

And in front end take straight table

Dimension1:- Client

Dimension2:- Category

Expression:- Sum(Revenue%)

and if in chart you want direct use of calculated dimension then use same expression

if(Revenue% >=10 and Revenue% <=30, 'Between 10-30',

if(Revenue% >=30 and Revenue% <=60, 'Between 30-60',

if(Revenue% >=60 and Revenue% <=90, 'Between 60-90',)))

Regards

Re: Sections in pie chart

MK_QSL — Mon, 14 Apr 2014 14:09:41 GMT

Please check enclosed file...

Re: Sections in pie chart

its_anandrjs — Mon, 14 Apr 2014 14:13:27 GMT

For pie chart take dimension

Dimension:- Category or you can use calculated dimension like

if(Revenue% >=10 and Revenue% <=30, 'Between 10-30',

if(Revenue% >=30 and Revenue% <=60, 'Between 30-60',

if(Revenue% >=60 and Revenue% <=90, 'Between 60-90',)))

Expression:-sum(Revenue%)

See the snap shot