Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
danm84306
New Contributor III

Sum If Total

Hello,

    

     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

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

2 Replies

Re: Sum If Total


Like this:

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

qlikviewwizard
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.