topic Re: how to write OR condition in the set analysis in QlikView

how to write OR condition in the set analysis

Wed, 16 Jul 2014 09:35:48 GMT

hi all,

As per the requirement, i need to write the condition combining 'and ' and 'OR' condition in the set analysis.

Please let me know ASAP.

Category like 'SYSTEM %'

or Categorylike 'HARDWARE%' in the single condition .

Thanks in advance,

Smitha

ashfaq_haseeb — Wed, 16 Jul 2014 09:45:46 GMT

Hi,

Try below

=sum({<Category = {'SYSTEM*','HARDWARE*'>}Amount)

Regards

ASHFAQ

avinashelite — Wed, 16 Jul 2014 09:49:09 GMT

Hi Smitha,

Please try like this:

sum({<Category={'SYSTEM %'},Category={'HARDWARE %'}>}amount)

or if(Category='SYSTEM %' or Category='HARDWARE %', sum(amount))

if(Category='SYSTEM %' and Category='HARDWARE %', sum(amount))

VishalWaghole — Wed, 16 Jul 2014 09:50:36 GMT

Hi Smitha,

Try this

=sum({<Category={'SYSTEM*'}> + <Category={'HARDWARE'}>} Amount)

Hope it will work for you.

-- Regards,

VIshal Waghole