Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
wonkymeister
Creator III
Creator III

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
RedSky001
Partner - Creator III
Partner - 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
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
zhuravlevleonid
zhuravlevleonid
zhuravlevleonid
zhuravlevleonid
zhuravlevleonid
zhuravlevleonid
zhuravlevleonid