topic Re: % Expression in QlikView

% Expression

kevbrown — Wed, 28 Mar 2018 13:15:13 GMT

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%

sunny_talwar — Wed, 28 Mar 2018 13:18:09 GMT

Maybe this

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

kevbrown — Wed, 28 Mar 2018 13:24:47 GMT

Thank you

sunny_talwar — Wed, 28 Mar 2018 13:35:58 GMT

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

kevbrown — Wed, 28 Mar 2018 13:38:59 GMT

Yes i did but thank you anyway.