Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

how to calculate the percentage

Hi Folks,

i got (and attached ) the file, where i having the issue regarding of calculation of percentage,

 

does anybody have any idea how to calcaluate the percentage, if i try to Show the sum of percentage, but i got the avg.

Thanks a lot

Beck

Labels (1)
4 Replies
Claudiu_Anghelescu
Specialist
Specialist

Untitled.png

I have used a Table Chart.

To help community find solutions, please don't forget to mark as correct.
beck_bakytbek
Master
Master
Author

Hi Claudiu,

first of all, thanks a lot for your time and help. My expected Output is, to calculate the percentage within / as expression and divide into 14,

your option shows the calculation of percentage as sum, but i need to calculate it as expression, because the sum of 1045, 07% i should divide into 14 and that gives me the 74, 64% (i want to have this result: 74,64%).

Do you have any idea?

Thanks a lot

Claudiu_Anghelescu
Specialist
Specialist

Instead of Sum please select AVG and you will have 74,65% as Total.

To help community find solutions, please don't forget to mark as correct.
beck_bakytbek
Master
Master
Author

Hi Claudiu,

 

thanks a lot for your time and Feedback, you didn't understand my issue: can i calculate or make the Expression, where i have the sum and this sum divide into 14, without selecting avg in the Setting within of table.

 

thanks a lot