Set Expression Query

[jagdishbr]

Hi, I'm new to Qlik Sense and I'm having trouble writing a set expression. I need to fetch the sum of sales where profit is 0 for each client.

I tried the following expression, but it's not working

=SUM({<profit={0},period={'FY23'}>}sales)

Where am I going wrong? Could you please help me understand?

[gomeri]

Hi,

expression have a right syntaxis, but I don't sure about your type of date.

Can you attach a screenshot of your table please? Or example?

Type of data in "profit" is numeric or textual?

Thanks

[jagdishbr]

HI Gomeri, It's textual.

[simsa · Accepted solution]

In case it is textual, please use the formula below:
=SUM({<profit={'0'},period={'FY23'}>}sales)

[gomeri · Accepted solution]

At this point I recommend that:

• you either transform, at the data model level, the dimension from text type to a number type (Num - script and chart function | Qlik Sense on Windows Help) or
• use the formula written by @simsa being aware that a text type measure is heavier in performance than a number type

I remain available for further information

Thanks