Qliksense Pie chart showing addtitional values

Aspiring_Developer — Mon, 08 Mar 2021 11:05:57 GMT

Hello everyone,

I came accross a very strange behaviour below:-

I have below dimensions and measures :-

Dimension:- =valuelist('Direct labour N-1', 'Indirect Labour N-1','Total SG&A + R&D N-1')

Measure:-

if(valuelist('Direct labour N-1', 'Indirect Labour N-1','Total SG&A + R&D N-1')='Direct labour N-1',

num(sum({<Indicateur.Code = {'PO.1.161b'},[Site.isYFPO]={'0'},[Site.Participe]={'49|50'},Date.Year = , Date.MonthName = , Date.Quarter =, Date.Month =, Date.MonthEnd =, MonthYear=,Date=,NewTestvb1=,
Date= {"$(=MonthStart(Max(Date)))"} >} [Indicateur.Value])
/

sum({<Indicateur.Code = {'PO.1.137b'},[Site.isYFPO]={'0'},[Site.Participe]={'49|50'},Date.Year = , Date.MonthName = , Date.Quarter =, Date.Month =, Date.MonthEnd =, MonthYear=,Date=,NewTestvb1=,
Date= {"$(=MonthStart(Max(Date)))"}>} [Indicateur.Value])
,'###.#%'),

if(valuelist('Direct labour N-1', 'Indirect Labour N-1','Total SG&A + R&D N-1')='Indirect Labour N-1',
num(sum({<Indicateur.Code = {'PO.1.162b'},[Site.isYFPO]={'0'},[Site.Participe]={'49|50'},Date.Year = , Date.MonthName = , Date.Quarter =, Date.Month =, Date.MonthEnd =, MonthYear=,Date=,NewTestvb1=,
Date= {"$(=MonthStart(Max(Date)))"} >} [Indicateur.Value])
/

if(valuelist('Direct labour N-1', 'Indirect Labour N-1','Total SG&A + R&D N-1')='Total SG&A + R&D N-1',

num(sum({<Indicateur.Code = {'PO.1.207b'},[Site.isYFPO]={'0'},[Site.Participe]={'49|50'},Date.Year = , Date.MonthName = , Date.Quarter =, Date.Month =, Date.MonthEnd =, MonthYear=,Date=,NewTestvb1=,
Date= {"$(=MonthStart(Max(Date)))"} >} [Indicateur.Value])
/
sum({<Indicateur.Code = {'PO.1.137b'},[Site.isYFPO]={'0'},[Site.Participe]={'49|50'},Date.Year = , Date.MonthName = , Date.Quarter =, Date.Month =, Date.MonthEnd =, MonthYear=,Date=,NewTestvb1=,
Date= {"$(=MonthStart(Max(Date)))"} >} [Indicateur.Value])
,'###.#%')

)

)
)

When i plot the above in bar chart , i get correct number s:-

But when i created a pie chart, it is showing some additional values like below:-

In the above chart, the number corresponding to label 'Values-14.0%' is correct. However, there is an additional label named 'share-17.0%' which i have not calculated but somehow it is appearing out of nowhere.

I am unable to understand why exactly it is working fine in bar chart and causing problem in pie chart.

Can anyone please help me if with this ? 😞

Re: Qliksense Pie chart showing addtitional values

Lisa_P — Mon, 08 Mar 2021 23:58:09 GMT

I think that for a pie chart you should have numbers not %s for a measure

Re: Qliksense Pie chart showing addtitional values

Aspiring_Developer — Tue, 09 Mar 2021 12:45:35 GMT

Hello ,

Thank you for your reply.

I solved it myself by following below steps:-

1) Go to 'Apperance' - -> 'Presentation tab and do below

Post doing this, it will start showing you the value of your expression.

However, when you will hover on the chart, it will still you the value of Share%. In order to remove that, we make use of Qliksesne tool tip feature. I followed the below steps:

1)Go to tool tip, check the checkbox 'hide basic rows' and enter details of your dimensions and measures

End Result:- It is showing actual values of the expression and no value for share is displayed

topic Qliksense Pie chart showing addtitional values in App Development

Qliksense Pie chart showing addtitional values

Re: Qliksense Pie chart showing addtitional values

Re: Qliksense Pie chart showing addtitional values