Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
New Contributor III

Sum If Total



     I am looking for the total of a sum if statement. I am doing this in order to set up a % of subtotal formula.

Sum If Example


2 Replies

Re: Sum If Total

Like this:

Sum(if(Type='T',Quantity)) /Sum (Total(Quantity))

Honored Contributor II

Re: Sum If Total

Hi DanM84306

Your requirement is not clear. Can you attach a sample file with the data to demonstrate your issue.

So that it will help folks to understand the issue and provide efficient solution.

Thank you.

Community Browser