Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Creator III
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'}>

} Heads)

View solution in original post

7 Replies
Highlighted
Master II
Master II

Re: OR operator in set analysis

See the attached file for set analysis

hope it helps

Highlighted
Creator
Creator

Re: OR operator in set analysis

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

Highlighted
Creator
Creator

Re: OR operator in set analysis

no that doesnt seem to work either

thanks for the PDF though, very useful

Highlighted
Master
Master

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

Highlighted
Creator III
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'}>

} Heads)

View solution in original post

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