Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to write OR condition in the set analysis

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

3 Replies

Hi,

Try below

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

Regards

ASHFAQ

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))

Specialist II
Specialist II

Hi Smitha,

Try this

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

Hope it will work for you.

-- Regards,

VIshal Waghole