Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
Like this?
Let me know if thsi is what you are looking for ok?
Good luck,
Dennis.
Hello Dennis,
Thanks for the response.
Could not able to open the file. I am using Qlikview 9 licesensed version.
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
Just go to the number tab, select the [In(%)] Expression and check Fixted to 1 decimal.
Is that what you are looking for?
It's not working actually. It is giving me 0.00%.
Hi sandeep
Go to number tab and uncheck the Show in percentage.
suresh
hi sandeep
Go to number tab and uncheck the percentage
thanks
Then also it is not working.. Tried in many aspects.
Can you please follow the test.qvw file.
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?