Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.

1 Solution

Accepted Solutions
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?

View solution in original post

12 Replies
Anonymous
Not applicable
Author

Like this?

Let me know if thsi is what you are looking for ok?

Good luck,

Dennis.

Not applicable
Author

Hello Dennis,

Thanks for the response.

Could not able to open the file. I am using Qlikview 9 licesensed version.

Not applicable
Author

Hi,

Please find attached of the .qvw file.

I need to calculate the percentage of log fees which shoul be in format '0.01'.

Thanks

Anonymous
Not applicable
Author

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

Is that what you are looking for?

Not applicable
Author

It's not working actually. It is giving me 0.00%.

Not applicable
Author

Hi sandeep

Go to number tab and uncheck the Show in percentage.

suresh

Not applicable
Author

hi sandeep

Go to number tab and uncheck the percentage

thanks

Not applicable
Author

Then also it is not working.. Tried in many aspects.

Can you please follow the test.qvw file.

Anonymous
Not applicable
Author

Change your expression to

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

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

Is that what you are looking for?