Sum values column A if condition is Column B is met

[ToinkToinkTigger]

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]

@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]

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

[sidhiq91]

@ToinkToinkTigger  Could you please post some sample data?

[ToinkToinkTigger]

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 · Accepted solution]

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

In the table form, please see below.

[ToinkToinkTigger]

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

[sidhiq91]

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

[ToinkToinkTigger]

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