Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
slsaagar
New Contributor II

How to calculate % divided by total in pivot

Hello experts

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

For your reference attaching the Sample data

1 Solution

Accepted Solutions
MVP
MVP

Re: How to calculate % divided by total in pivot

You need to use TOTAL qualifier with a field list:

=Count(Backlog)

/

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

View solution in original post

3 Replies
MVP
MVP

Re: How to calculate % divided by total in pivot

You need to use TOTAL qualifier with a field list:

=Count(Backlog)

/

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

View solution in original post

slsaagar
New Contributor II

Re: How to calculate % divided by total in pivot

swuehl Thanks it worked

Re: How to calculate % divided by total in pivot

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

Best,

Sunny