Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Arjunarao
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