topic Re: OR operator in set analysis in QlikView

OR operator in set analysis

wonkymeister — Fri, 07 Jun 2013 09:18:18 GMT

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?

(Grades={'A'} OR PredictedGrades={'A'})

?????

cheers in advance people

Wonky.

Re: OR operator in set analysis

er_mohit — Fri, 07 Jun 2013 09:22:50 GMT

See the attached file for set analysis

hope it helps

Re: OR operator in set analysis

wonkymeister — Fri, 07 Jun 2013 09:22:50 GMT

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

Re: OR operator in set analysis

wonkymeister — Fri, 07 Jun 2013 09:40:48 GMT

no that doesnt seem to work either

thanks for the PDF though, very useful

Re: OR operator in set analysis

Sokkorn — Fri, 07 Jun 2013 09:42:03 GMT

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

Re: OR operator in set analysis

RedSky001 — Fri, 07 Jun 2013 09:43:23 GMT

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

Re: OR operator in set analysis

wonkymeister — Fri, 07 Jun 2013 09:58:23 GMT

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 )

Re: OR operator in set analysis

zhuravlevleonid — Fri, 27 Jul 2018 11:37:52 GMT

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