Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ivan_will
Partner - Creator II
Partner - Creator II

Set analyses ? - using OR

hello,

how can I convert this function - sum ( distinct IF (a='1' OR a='2 , (b) , 0)) into set analyses function ?

sum ( { $<a = {'1' ???????????? '2'}>} b)

6 Replies
Anonymous
Not applicable

this should do:

sum( $ {< a = {'1','2'} >} b)

Anita

ivan_will
Partner - Creator II
Partner - Creator II
Author

😞 no, it doesn't work !

Miguel_Angel_Baeyens

If that concerns to distinct, try

Sum({< a = {"1","2"} >} DISTINCT b)


Miguel_Angel_Baeyens

Even, when working with numeric values

Sum({< a = {1,2} >} DISTINCT b)


ivan_will
Partner - Creator II
Partner - Creator II
Author

No , it does not work again ! I need - OR

This function Sum({< a = {1,2} >} b) = + between 1and 2 /////// , - means +

Anonymous
Not applicable

a = {1,2} means that a should be 1 or 2