Conditional aggragate function

Ericus — Wed, 09 Feb 2022 12:53:21 GMT

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?

Re: Conditional aggragate function

chris_djih — Wed, 09 Feb 2022 13:58:00 GMT

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/

topic Re: Conditional aggragate function in App Development

Conditional aggragate function

Re: Conditional aggragate function