topic Re: Sum values column A if condition is Column B is met in App Development

Sum values column A if condition is Column B is met

ToinkToinkTigger — Thu, 13 Oct 2022 11:40:44 GMT

Hello there,

I have a dataset with two columns of interest. Column A and Column B.

I want to return the Sum value of Column A for when the fieldvalue of Column B equals 167000

How is this syntax written?

Thanks in advance,

sidhiq91 — Thu, 13 Oct 2022 11:49:36 GMT

@ToinkToinkTigger You can use the set expression:

Sum({<[Column B]={'167000'}>}[Column A])

If this resolves your issue, please like and accept it as a solution

ToinkToinkTigger — Thu, 13 Oct 2022 12:01:09 GMT

That does not work unfortunately, it return the value 0 for all fields.

sidhiq91 — Thu, 13 Oct 2022 12:25:25 GMT

@ToinkToinkTigger Could you please post some sample data?

ToinkToinkTigger — Thu, 13 Oct 2022 12:48:21 GMT

Yes, sure,

So the entries have a WBS Element ID (Col A). Column G distinguishes between 600500 (Capital Invesmtnets) and 617000 (Temporary Staff)

I would like to sum the actual costs for lets say temporary staff in an expression

sidhiq91 — Thu, 13 Oct 2022 13:00:01 GMT

@ToinkToinkTigger Please see the below KPI, which works perfectly fine.

In the table form, please see below.

ToinkToinkTigger — Thu, 13 Oct 2022 13:04:17 GMT

Strange, can this have to do anything with using a lower Qliksense version? (not the newest)?

sidhiq91 — Thu, 13 Oct 2022 13:10:10 GMT

@ToinkToinkTigger It will work in any version. It has nothing to do with the version of the Qlik.

ToinkToinkTigger — Thu, 13 Oct 2022 14:47:57 GMT

Thanks, worked out in the end. Had a dumb typo in there 🙂 Thanks for the quick help, much appreciated.