Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Max1984
Contributor III
Contributor III

Show the cost percentages of the legend on a pie chart

Hi everybody,

I would like to make a pie chart where to report the sums of costs in the legend and the percentages on the chart.

Image.jpg

How can I do? I attach the files

thank you

Labels (3)
7 Replies
dplr-rn
Partner - Master III
Partner - Master III

try something like below

dual( your_sum_expression & '  - ' & your_percent_expression,your_sum_expression)

Max1984
Contributor III
Contributor III
Author

Hello,with your expression I don't get what I want.

image.jpg

The bar chart has no dimension but only five expressions of which the "Costo Dipendenti" is calculated from one table and the remaining costs from another table according to the categories. I would like to make the following chart:

image.jpg

thank you

Max1984
Contributor III
Contributor III
Author

even so it's fine:

 

image.png

check the formula used for example for the cost "Costo dipendenti":

dual(
     SUM(AGGR(MAX({<[Mese Emolumenti]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>} [# Importo Emolumenti]),[% Id Emolumenti]))
          /
       (SUM({<[Master Calendar Date Calc]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>}[# Imponibile Squadra]) + SUM({<[Mese Emolumenti]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>} [# Importo Emolumenti]))
        
      & '  - ' & 
      
     ( SUM(AGGR(MAX({<[Mese Emolumenti]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>} [# Importo Emolumenti]),[% Id Emolumenti]))
     
     /
     
    (SUM({<[Master Calendar Date Calc]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>}[# Imponibile Squadra]) + SUM({<[Mese Emolumenti]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>} [# Importo Emolumenti]))) * 100,
     
     
    SUM(AGGR(MAX({<[Mese Emolumenti]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>} [# Importo Emolumenti]),[% Id Emolumenti]))
     
     /
     
     (SUM({<[Master Calendar Date Calc]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>}[# Imponibile Squadra]) + SUM({<[Mese Emolumenti]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>} [# Importo Emolumenti]))
       
     )
     

 

thank you

Max1984
Contributor III
Contributor III
Author

First mistake I made in the first expression I just have to put the cost and enter the Num function with formatting.
I already got such a thing using this expression:

 

Dual(
      Num(SUM(AGGR(MAX({<[Mese Emolumenti]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>} [# Importo Emolumenti]),[% Id Emolumenti])),'€ #.##0,00;-€ #.##0,00')     
      
      & ' (' & Num(SUM(AGGR(MAX({<[Mese Emolumenti]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>} [# Importo Emolumenti]),[% Id Emolumenti]))
      /
     (SUM({<[Master Calendar Date Calc]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>}[# Imponibile Squadra]) + SUM({<[Mese Emolumenti]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>} [# Importo Emolumenti])),'#.##0,00%')
            
       &')',Num(SUM(AGGR(MAX({<[Mese Emolumenti]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>} [# Importo Emolumenti]),[% Id Emolumenti])),'€ #.##0,00;-€ #.##0,00')
     )

image.jpg

how can it be solved?

thank you

Kushal_Chawda

see the attached

Max1984
Contributor III
Contributor III
Author

Hello kush1,

my files are attached in the initial post, however I think that what I request is not feasible. My pie chart has no dimensions but only five expressions. The problem is that I can't get both the euro currency in the legend and the% in the chart.

regards

Brett_Bleess
Former Employee
Former Employee

Max, I believe you are correct after looking over the Help, if you want to have a look for yourself, here is the link:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Pie_Chart.htm

I checked one of the sample apps that has a pie chart in it, and it is setup like what you ended up with in that the legend had values, but that was it, nothing in the pie slices as you wanted, and I cannot see anywhere that you could add this even with a Dimension.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.