topic can we use 'OR' in Set analysis? in QlikView

can we use 'OR' in Set analysis?

Tue, 04 Jun 2013 15:48:26 GMT

can we use 'OR' in set analysis?

Ex:

client ID='1234' or '5678'

Anonymous — Tue, 04 Jun 2013 15:57:31 GMT

OR Same Field

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

OR different field

Tue, 04 Jun 2013 16:09:42 GMT

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 — Tue, 04 Jun 2013 16:25:52 GMT

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

johanlindell — Tue, 04 Jun 2013 16:26:56 GMT

It should look like:

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

/Johan

Tue, 04 Jun 2013 19:38:45 GMT

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 — Tue, 04 Jun 2013 19:56:54 GMT

For AND use this operator *

Wed, 05 Jun 2013 15:55:22 GMT

Thanks for the help Mohit.