Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kevbrown
Creator II
Creator II

% Expression

I have at pivot table that I'm looking to add a % to but it's not a forward as x/y*100. I have -

Name     Matched          Number     Matched %     Unmatched %

1             Matched          3

1             Matched          6

1             Matched          7

1             Matched          3

1             Unmatched      4

2             Matched          4

2             Matched          5

So, for Name 1 I want the % for Matched and Unmatched.  The sum for matched would be 3/(6+7+3)=18.75% but how do i do that with the fields above?

Unmatched would be 4/4=100%

1 Solution

Accepted Solutions
sunny_talwar

Maybe this

Sum({<Matched = {'Matched'}>} Number)/Sum({<Matched = {'Matched'}>} TOTAL <Name> Number)

View solution in original post

4 Replies
sunny_talwar

Maybe this

Sum({<Matched = {'Matched'}>} Number)/Sum({<Matched = {'Matched'}>} TOTAL <Name> Number)

View solution in original post

kevbrown
Creator II
Creator II
Author

Thank you

sunny_talwar

I had a typo in my expression... which I have fixed now... but I guess you already spotted it on your end

kevbrown
Creator II
Creator II
Author

Yes i did but thank you anyway.