# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for
Did you mean:
Highlighted
Creator

## OR operator in set analysis

drowning in set analysis as per usual!

something so simple yet appears so difficult, an OR in my sum. how to OR???

=sum({Capps<

Year={'\$(vYear)'},

Decision={'Offer'},

Response={'Firm'},

Location={'L','N'},

/////////////////////

////////////////////

Semester={'Semester 1'}

do i stick brackets around both?

ie

?????

Wonky.

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Creator III

## Re: OR operator in set analysis

=sum({Capps

<Year={'\$(vYear)'}, Decision={'Offer'}, Response={'Firm'}, Location={'L','N'}, Semester={'Semester 1'},Grades={'A'}>

+

<Year={'\$(vYear)'}, Decision={'Offer'}, Response={'Firm'}, Location={'L','N'}, Semester={'Semester 1'},PredictedGrades={'A'}>

7 Replies
Highlighted
Master II

## Re: OR operator in set analysis

See the attached file for set analysis

hope it helps

Highlighted
Creator

## Re: OR operator in set analysis

thanks but the + sign doesnt work, including the + sign throws an error.

Highlighted
Creator

## Re: OR operator in set analysis

no that doesnt seem to work either

thanks for the PDF though, very useful

Highlighted
Master

## Re: OR operator in set analysis

Hi Wonky,

Not sure you try this yet:

Regards,

Sokkorn

Highlighted
Creator III

## Re: OR operator in set analysis

=sum({Capps

<Year={'\$(vYear)'}, Decision={'Offer'}, Response={'Firm'}, Location={'L','N'}, Semester={'Semester 1'},Grades={'A'}>

+

<Year={'\$(vYear)'}, Decision={'Offer'}, Response={'Firm'}, Location={'L','N'}, Semester={'Semester 1'},PredictedGrades={'A'}>

Highlighted
Creator

## Re: OR operator in set analysis

cheers everyone, prompt and speedy replies and problem solved (cheers Mark)

its a whole new world this set analysis malrky mind, i'm really enjoying working with QlikView but blimey some of the syntax is crazy!!!

thanks again (Wonky is a very happy fella )

Highlighted
Contributor II

## Re: OR operator in set analysis

Is there any posibilites not to copy all other conditions in set analysis?

I mean if i have conditions A, B, C, D, E or F

I should write them like {<A, B, C, D, E> + <A, B, C, D, F>}

And if i have two "OR " operators i should describe 4 sets:

A, B, C or D, E or F will look like:

{<A, B, C, E> + <A, B, C, F> + <A, B, D, E> + <A, B, D, F>}

And so on..