6 Replies Latest reply: Jun 7, 2013 5:42 AM by Sokkorn Cheav

# OR operator in set analysis

help please

drowning in set analysis as per usual!

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

example - how do i OR the Grades/PredictedGrades?

=sum({Capps<

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

Decision={'Offer'},

Response={'Firm'},

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

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

Grades={'A'} OR PredictedGrades={'A'}

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

Semester={'Semester 1'}

>} Heads)

do i stick brackets around both?

ie

(Grades={'A'} OR PredictedGrades={'A'})

?????

cheers in advance people

Wonky.

• ###### Re: OR operator in set analysis

See the attached file for set analysis

hope it helps

• ###### Re: OR operator in set analysis

no that doesnt seem to work either

thanks for the PDF though, very useful

• ###### Re: OR operator in set analysis

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

• ###### Re: OR operator in set analysis

Hi Wonky,

Not sure you try this yet:

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

Regards,

Sokkorn

• ###### 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'}>

} Heads)

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