topic Re: Percentage Caluclation in QlikView

Percentage Caluclation

Thu, 01 Dec 2011 08:04:36 GMT

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.

Re: Percentage Caluclation

Anonymous — Thu, 01 Dec 2011 09:28:42 GMT

Like this?

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

Good luck,

Dennis.

Re: Percentage Caluclation

Thu, 01 Dec 2011 10:00:00 GMT

Hello Dennis,

Thanks for the response.

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

Re: Percentage Caluclation

Thu, 01 Dec 2011 10:09:25 GMT

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

Re: Percentage Caluclation

Anonymous — Thu, 01 Dec 2011 10:19:58 GMT

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

Is that what you are looking for?

Re: Percentage Caluclation

Thu, 01 Dec 2011 10:27:10 GMT

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

Re: Percentage Caluclation

Thu, 01 Dec 2011 10:51:10 GMT

Hi sandeep

Go to number tab and uncheck the Show in percentage.

suresh

Re: Percentage Caluclation

Thu, 01 Dec 2011 10:52:53 GMT

hi sandeep

Go to number tab and uncheck the percentage

thanks

Re: Percentage Caluclation

Thu, 01 Dec 2011 11:23:15 GMT

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

Can you please follow the test.qvw file.

Re: Percentage Caluclation

Anonymous — Thu, 01 Dec 2011 11:29:39 GMT

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?

Re: Percentage Caluclation

Thu, 01 Dec 2011 11:43:22 GMT

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.

Re: Percentage Caluclation

Anonymous — Thu, 01 Dec 2011 11:57:13 GMT

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

what do you get?

Re: Percentage Caluclation

Thu, 01 Dec 2011 12:20:14 GMT

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.