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

Percentage Caluclation

Hello All,

Please find attach of the qvw file.

I need to calculate the Log Fees percentage. Could not able to achive it.

Please assist.

12 Replies
Not applicable
Author

Hi Dennis,

This is also not helping. I have tries this as well.

Can you please follow the test.qvw. And please provide me with the sample.

Many Thanks.

Anonymous
Not applicable
Author

I am following your test.qvw

When I change your expression to:

     sum([Log fees])/sum({1} total [Log fees]) *100

And then go to the number tab, select the [In(%)] Expression and check Fixted to 1 decimal.

Then I do get the right info imo

percent.JPG

what do you get?

Not applicable
Author

Yeah Dennis I am getting the result.

It was giving me trouble as the calculated percentage is big , so when I limited it till 0.00, it was giving 0.00%.

Many Thanks.