Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=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)
See the attached file for set analysis
hope it helps
thanks but the + sign doesnt work, including the + sign throws an error.
no that doesnt seem to work either
thanks for the PDF though, very useful
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
=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)
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 )
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..