Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
alespooletto
Creator II
Creator II

Show percentages on Stacked Bar chart

Hello, I would like to show the percentages for each of the dimension values instead of the sheer values. How can I do this in this chart?

alespooletto_1-1737535235612.png


Here an excerpt of the data

Risorsa Conformità Risorsa
User1 Conforme 100
User1 Non Conforme 48
User2 Conforme 3
User2 Non Conforme 1
User3 Conforme 47
User3 Non Conforme 40
User4 Conforme 105
User4 Non Conforme 13
Labels (1)
4 Replies
Clement15
Partner - Specialist
Partner - Specialist

Hello,

Does this measure meet your needs?
Sum(Risorsa)/sum(total Risorsa)

JandreKillianRIC
Partner Ambassador
Partner Ambassador

Hi @alespooletto 

 

Please see attached. 

JandreKillianRIC_0-1737541616027.png

 

Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn

alespooletto
Creator II
Creator II
Author

@JandreKillianRIC hello, thanks  a lot for your help. 

 

For some reasons, I can't import the .qvf into my QMC. I am afraid it's because my company doesn't allow external qvfs. Could you kindly point me to the resolution? 

JandreKillianRIC
Partner Ambassador
Partner Ambassador

Hi @alespooletto 

JandreKillianRIC_0-1737555050914.png

 

Conforme

Sum({<[Conformità] = {'Conforme'}>} Risorsa2)
/
Sum(Total Risorsa2)

JandreKillianRIC_1-1737555088488.png

 

Non Conforme

Sum({<[Conformità] = {'Non Conforme'}>} Risorsa2)/
Sum(Total Risorsa2)

JandreKillianRIC_2-1737555117205.png

And then on the Presentation Tab 

JandreKillianRIC_3-1737555146035.png

 

Regards - Jandre

 

 

 

Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn