topic Re: pie chart display only one segment. in QlikView

pie chart display only one segment.

Anonymous — Fri, 01 Aug 2014 12:37:51 GMT

hi community,

i have 4 regions , region1.==25%

region 2==25%

region3==25%

region4 ==25%

i need to display like this :

segment1:25%

segment2:75% (regio2+region3+region4)

region 1 is not largest or smallest value to do dimension limit option

thanks,

Re: pie chart display only one segment.

VishalWaghole — Fri, 01 Aug 2014 13:13:11 GMT

Hi,

You need to edit script for that,

Load RegionColumn,

if(match(RegionColumn,'region1'),'Segment1','Segment2') as RegionFlag

From SourceFile;

then go to pie chart properties and drag RegionFlag as Dimension

and make your expression as it is.

If need more clarity then provide me some dummy data so i can help you.

-- Regards,

Vishal Waghole

Re: pie chart display only one segment.

Anonymous — Fri, 01 Aug 2014 13:43:24 GMT

hi vishal ,

thanks for ur time ,its working fine as static report ,means with out selections.

but if i select region 1,region2 its showing showing 100%

can u help me on this

Re: pie chart display only one segment.

VishalWaghole — Fri, 01 Aug 2014 14:02:21 GMT

Hi,

Make your expression as like,

=sum ({<RegionColumn = >} YourFactColumn)

if you want count then insted of sum write Count,

Only understand Set Analysis that i have used.

-- Regards,

Vishal Waghole

Re: pie chart display only one segment.

lawrenceiow — Fri, 01 Aug 2014 15:27:25 GMT

Create your Pie Chart using Add Calculated Dimension

Use: if(Aggr(Sum(1), Region)>0,Region,'Others')

The Expression in your Chart will be sum({<Region=>}Sales)

Replace Sales with whatever is your Measure.

Your Pie will appear as normal to start with - ie 4 regions with equal segments. Whichever segment you select, the others will be grouped together as a single segment.

Re: pie chart display only one segment.

Fri, 01 Aug 2014 15:33:49 GMT

you try calculated dimension like

if(match(region='Region1'),'Segment1','Segment2'))

Re: Re: pie chart display only one segment.

Anonymous — Fri, 01 Aug 2014 17:03:01 GMT

hi lawrence,

thanks for ur time.

pfa