topic Sum If Total in QlikView

Sum If Total

danm84306 — Tue, 28 Jul 2015 16:20:20 GMT

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))

robert_mika — Tue, 28 Jul 2015 16:34:15 GMT

Like this:

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

qlikviewwizard — Tue, 28 Jul 2015 16:38:46 GMT

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.