Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
knightwriter
Creator III
Creator III

% of Count?

Hi All,

How do I formulate a percentage of the overall total for each of the columns in my straight table?

Kind regards

1 Solution

Accepted Solutions
sunny_talwar

May be this is what you are looking for:

Count(Field)/Count(Total Field)

View solution in original post

2 Replies
sunny_talwar

May be this is what you are looking for:

Count(Field)/Count(Total Field)

swuehl
MVP
MVP

You can try enabling 'relative' option in your expression tab or use something like

=sum(Value) / sum(TOTAL Value)