OR operator in set analysis

[wonkymeister]

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.

[er_mohit]

See the attached file for set analysis

hope it helps

[wonkymeister]

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

[wonkymeister]

no that doesnt seem to work either

thanks for the PDF though, very useful

[Sokkorn]

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

[RedSky001 · Accepted solution]

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

[wonkymeister]

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 )

[zhuravlevleonid]

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