How to calculate % divided by total in pivot

[slsaagar]

Hello experts

I want to calculate % of ordercount/Total. i am getting wrong % in Qlikview Please Help

For your reference attaching the Sample data

[swuehl · Accepted solution]

You need to use TOTAL qualifier with a field list:

=Count(Backlog)

/

count(TOTAL<OrderType,ProdGroup> (Backlog))

[slsaagar]

swuehl Thanks it worked

[sunny_talwar]

sagar‌ if you got the answer you were expecting, I would suggest closing the thread by marking swuehl‌ answer as correct answer.

Best,

Sunny