Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@Mahamed_Qlik This is the right set modifier expression on how you're trying to do it.
Sum({$<Region={'UK'}>+<Region={'US'}>} Total)
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 )
@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.
@Mahamed_Qlik This is the right set modifier expression on how you're trying to do it.
Sum({$<Region={'UK'}>+<Region={'US'}>} Total)