Set analysis

[Mahamed_Qlik]

Hi

How to write "OR" condition in set analysis expression for multiple values in single field.

Region   Total

UK            100

US             200

INDIA       400

AFRICA   500

I want to take sum of total for region "UK" or "US".

SUM({<Region={'UK'}+ Region={'US'}>}Total)   ---> its not working.

[vinieme12]

OR can evaluated as below

in-case of multiple values in same field

Option1)      SUM({<Region={'UK','US'}>}Total)

in-case of values in different fields

Option2) Sum({<Region={‘UK’}>+<OTHRfld={‘SomeValue’}> Total )

[sidhiq91]

@Mahamed_Qlik  Please use the below code:

Sum({<Region={'UK','US'}>}Total)

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

[BrunPierre · Accepted solution]

@Mahamed_Qlik This is the right set modifier expression on how you're trying to do it.

Sum({$<Region={'UK'}>+<Region={'US'}>} Total)