topic Re: Adding values on data points in Pie Charts in QlikView

Adding values on data points in Pie Charts

Mon, 15 Aug 2011 08:14:00 GMT

I'm trying to add values on data points in a pie chart. I have added the dimension,unchecked the legen,created an expression with just the dimension- no claculation on it and checked that as value on data point. I still see no values. Any suggestions?

Adding values on data points in Pie Charts

IAMDV — Mon, 15 Aug 2011 09:11:52 GMT

Hi,

Please can you post the sample QV document with scrambleddata? It will be easier to look into the chart.

Cheers - DV

Adding values on data points in Pie Charts

Anonymous — Mon, 15 Aug 2011 11:58:25 GMT

Normally the things you said are working. I made an example myself and no problem. A look in de qvw file will help!

Arjan

Re: Adding values on data points in Pie Charts

Mon, 15 Aug 2011 12:23:15 GMT

OpenIssues:
load
 [ID] as Count 
 ,[Issue Status]as Status , [Risk Rating] as Rating
 , [Issue Date] as OpenDate , Year as [Year Opened], [Business Unit] as BusinessResponsible, [Business Area] as BusinessArea, Title as Titles, 
 [Issue Description]as Description,
 [Reporting Source] as ReportingSource, 
 
  
[Issue Owner] as Owner,
[Revised Issue Due Date] as RevisedDueDate,
[Original Due Date]as OriginalDueDate,
Date(if([Revised Issue Due Date]>0,[Revised Issue Due Date],[Original Due Date]),'M/D/YYYY') as [Due Date],
if ([Business Unit]='GM' or [Business Unit]='IB' or [Business Unit]= 'TR' , 'Frontline' ,'Support') as [Frontline/SupportBusiness]
FROM File 
(ooxml, embedded labels, table is [Data])
Where [Issue Status]='Open'
 
 
 Here is my code

Adding values on data points in Pie Charts

Anonymous — Mon, 15 Aug 2011 12:42:40 GMT

Which fields are you using in de Pie chart?

Gr,

Arjan

Adding values on data points in Pie Charts

Mon, 15 Aug 2011 12:44:12 GMT

Hi Madelein,

Why not uploading an actual sample Qlikview file (.qvw), so we may have an easier look on the pie chart you've created? here you've just sent us the loading codes.

Regards.

Re: Adding values on data points in Pie Charts

Mon, 15 Aug 2011 13:11:24 GMT

Here you go

Adding values on data points in Pie Charts

swuehl — Mon, 15 Aug 2011 13:16:09 GMT

Hi,

if you choose an non 3-D style of pie chart presentation, you will get your numbers.

Stefan

Adding values on data points in Pie Charts

Anonymous — Mon, 15 Aug 2011 13:21:21 GMT

Hi,

Problem is in the chart.....I've tried a new one with the same dimension and expression. It works fine!

My version of qlikview is 10.00.8935.7 SR2.

Regards,

Re: Adding values on data points in Pie Charts

Mon, 15 Aug 2011 13:30:29 GMT

Thanks that works!!