Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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.

Tags (1)
1 Solution

Accepted Solutions
dennisnet
Valued Contributor III

Re: Percentage Caluclation

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?

12 Replies
dennisnet
Valued Contributor III

Re: Percentage Caluclation

Like this?

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

Good luck,

Dennis.

Not applicable

Re: Percentage Caluclation

Hello Dennis,

Thanks for the response.

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

Not applicable

Re: Percentage Caluclation

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

dennisnet
Valued Contributor III

Re: Percentage Caluclation

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

Re: Percentage Caluclation

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

Not applicable

Re: Percentage Caluclation

Hi sandeep

Go to number tab and uncheck the Show in percentage.

suresh

Not applicable

Re: Percentage Caluclation

hi sandeep

Go to number tab and uncheck the percentage

thanks

Not applicable

Re: Percentage Caluclation

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

Can you please follow the test.qvw file.

dennisnet
Valued Contributor III

Re: Percentage Caluclation

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?