topic Re: Total percentage in Table help in QlikView

Total percentage in Table help

joshrussin — Wed, 25 Nov 2020 16:16:04 GMT

Hey everyone,

I am trying to get the percentage of goods issued. The count is correct, but when I try to get the percentage, it is missing 0.7 percent. In the excel spreadsheet there is a row of "#N/A" that accounts for the 0.07 percent. How do I get rid of this? Attached is the excel and qlikview file.

Re: Total percentage in Table help

sunny_talwar — Wed, 06 Sep 2017 16:55:59 GMT

You had an extra underscore in your set analysis field name Goods Issue Status... try this

Count({<[Goods Issue Status]={'Completed','Not Started'}>}[Goods Issue Status]) / Count({<[Goods Issue Status]={'Completed','Not Started'}>}Total [Goods Issue Status])

Re: Total percentage in Table help

joshrussin — Wed, 06 Sep 2017 17:54:12 GMT

I figured it was something minuscule. Just could find it. Thanks so much Sunny!