Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
joshrussin
Creator III
Creator III

Total percentage in Table help

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.

1 Solution

Accepted Solutions
sunny_talwar

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])


Capture.PNG

View solution in original post

2 Replies
sunny_talwar

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])


Capture.PNG

joshrussin
Creator III
Creator III
Author

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