topic Re: Pie chart not showing properly in QlikView

Pie chart not showing properly

Fri, 18 Apr 2014 22:10:07 GMT

I followed the instructions to create a slice called "others" as per the instructions in my book. But, I don't see "others" next to the percentage for "others" group.

Instructions -

1. Right-click on the pie chart and select Properties….

2. Go to the Expressions tab, and select Add to add a new expression.

3. Enter the following expression:

if(count(distinct [Carrier Name]) = 1, [Carrier Name], 'Others')

4. For the Label field of the expression, enter Carrier and enable the Values on

Data Points option.

Re: Pie chart not showing properly

Sat, 19 Apr 2014 07:49:07 GMT

Can u attach ur sample QVW file?

Re: Pie chart not showing properly

arulsettu — Sat, 19 Apr 2014 08:25:07 GMT

in properties dimensions limits tab enable show others...

hope it helps

Re: Pie chart not showing properly

MK_QSL — Sat, 19 Apr 2014 11:32:05 GMT

Follow below steps....

Create a Pie Chart

Dimension

[Carrier Name]

Dimension Limit

Tick Restrict Which Values are Displayed Using the First Expression

Show Only Values that Accumulate to

50% Relative to the Total Use Largest Value

Tick Include Boundary Values

Tick Show Others

Expression (Two Expressions)

SUM([# Transported Passengers])

Tick Values on Data Points

IF(Count(DISTINCT [Carrier Name])=1, [Carrier Name],'Others')

Tick Values on Data Points

Re: Pie chart not showing properly

Sat, 19 Apr 2014 11:56:25 GMT

HI ,

I guess it won't show you the label ,As Values on Data Points only give the values and lemme now if labels with values are possible.

Thanks

Saurabh

Re: Pie chart not showing properly

MK_QSL — Sat, 19 Apr 2014 12:00:15 GMT

Try it and let me know !!

Re: Pie chart not showing properly

Sat, 19 Apr 2014 12:30:49 GMT

Dear Manish,

I tried but it wasn't showing the labels.. its showing only values..

Could you Pls share the sample Qvw in which i can see the both .

Thanks ..

Re: Re: Pie chart not showing properly

MK_QSL — Sat, 19 Apr 2014 12:35:13 GMT

Check enclosed file..

Re: Pie chart not showing properly

Sat, 19 Apr 2014 12:55:22 GMT

Thanks alot Manish

Re: Pie chart not showing properly

Sat, 19 Apr 2014 23:56:53 GMT

In presentation tab, I had unchecked show legend because I only wanted to see the pie. I still don't know why there is no 'others' next to that 49%. I am attaching my qvw file. Please help me to make it work.

Thanks.

Re: Pie chart not showing properly

MK_QSL — Sun, 20 Apr 2014 06:33:16 GMT

Dear John,

When I download and open your QVW, I can see others also.

Which QlikView version are you using? If not 11.20, try to install the same.

I am not 100% sure, but if you are not able to see same PIE chart as below, there could be a BUG in your QlikView Version.

In this case, you need to update your apps.

ALSO, try to open the MRK275 190414 which I have enclosed for Saurabh. If in this file, Others not visible to you, there must be a BUG and please update your apps.