can we use 'OR' in Set analysis?

[#1]

can we use 'OR' in set analysis?

Ex:

client ID='1234' or  '5678'

[Anonymous]

OR Same Field

sum({$<ClientId = {1234,5678}>}field)

OR different field

http://community.qlik.com/message/188159

[#3]

To be more specific what if

client ID='PLESC' or 'ESILDR'

can i be able to use the same syntax for the string as well, i have give it a try but not working?

count({<$PMT={'101'},Client_ID=?>}trans id)

what should be the syntax i shoud be using for this?

[Anonymous · Accepted solution]

count({$<PMT={'101'},Client_ID= {'PLESC','ESILDR'}>}trans id)

[johanlindell]

It should look like:

count({<$PMT={'101'},Client_ID={'PLESC','ESILDR'}>} trans id)

/Johan

[#6]

Mohit, thanks for the help it worked anyway in your expression does the '+'(PMT={'101'}+Client_ID={'PLESC','ESILDR'})

sign implies to be as 'AND'?

count(Distinct {$<PMT={'101'}+Client_ID={'PLESC','ESILDR'}>} trans id)

[er_mohit]

For AND use this operator *

[#8]

Thanks for the help Mohit.