Conditional aggragate function

[Ericus]

I'm still learning Qlik and this is probably fairly easy, but I haven't managed to figure it out. I have created a pivot table for an app which groups all invoice posts to showcase all costs invoiced to a customer. But they also want to know how much they have consumed. Consumption is the number data from a specific set of products so I was wondering how I might write a function that can conditionally summarize only a sertain set of values like the SUMIF function from excel. Can I combine the Sum and the IF function in some way to do this?

[chris_djih · Accepted solution]

you could easily use something like this:  If( x<y, sum(z)) in your epression.
But there is a far better way in Qlik, named Set-Analysis. Please have some looks into this and try to use this instead of If-statements. Since If-Statements decreases your performance (in Measures).


further readings: https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/