Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
if you choose an non 3-D style of pie chart presentation, you will get your numbers.
Stefan
Hi,
Please can you post the sample QV document with scrambleddata? It will be easier to look into the chart.
Cheers - DV
Normally the things you said are working. I made an example myself and no problem. A look in de qvw file will help!
Arjan
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
Which fields are you using in de Pie chart?
Gr,
Arjan
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.
Here you go
Hi,
if you choose an non 3-D style of pie chart presentation, you will get your numbers.
Stefan
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,
Thanks that works!!