Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

1 Solution

Accepted Solutions
Creator III
Creator III

=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
Master II
Master II

See the attached file for set analysis

hope it helps

Creator
Creator

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

Creator
Creator

no that doesnt seem to work either

thanks for the PDF though, very useful

Master
Master

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

Creator III
Creator III

=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

Creator
Creator

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 )

Contributor II
Contributor II

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