Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

wonkymeister
Contributor

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.

Tags (1)
1 Solution

Accepted Solutions
msheraton
Contributor 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'}>

} Heads)

7 Replies
er_mohit
Honored Contributor II

Re: OR operator in set analysis

See the attached file for set analysis

hope it helps

wonkymeister
Contributor

Re: OR operator in set analysis

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

wonkymeister
Contributor

Re: OR operator in set analysis

no that doesnt seem to work either

thanks for the PDF though, very useful

Sokkorn
Honored Contributor

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

msheraton
Contributor 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'}>

} Heads)

wonkymeister
Contributor

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 )

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

Community Browser