topic Re: Set Analysis OR Condition in QlikView

Set Analysis OR Condition

manojkulkarni — Tue, 26 Jul 2016 04:47:58 GMT

Morning Friends,

How to write multi conditional OR statement in Set Analysis ?

I would need a condition to identify students who secured 90% in either Maths or Physics.

Below is the sample data

SID	Sname	Physics	Maths	Chem
1	ABC	95	90	90
2	XYZ	85	65	78
3	PQR	60	90	58
4	EFG	98	50	55

Re: Set Analysis OR Condition

arulsettu — Tue, 26 Jul 2016 04:58:18 GMT

may be this

Count({<Maths={'>=90'}>}Sname)+Count({<Chem={'>=90'}>}Sname)

Re: Set Analysis OR Condition

manojkulkarni — Tue, 26 Jul 2016 05:09:14 GMT

I am using the same expression. Is there a way to put both conditions in same set expression ?

Re: Set Analysis OR Condition

arulsettu — Tue, 26 Jul 2016 05:12:59 GMT

like this

Count({<Maths={'>=90'}>+<Physics={'>=90'}>}Sname)

Re: Set Analysis OR Condition

MayilVahanan — Tue, 26 Jul 2016 05:17:08 GMT

Try like this

Count({<Maths={'>=90'}>+<Physics={'>=90'}>}Sname)

SID	Sname	Maths	Physics	Count({<Maths={'>=90'}>+<Physics={'>=90'}>}Sname)
				3
1	ABC	90	95	1
3	PQR	90	60	1
4	EFG	50	98	1

Re: Set Analysis OR Condition

MindaugasBacius — Tue, 26 Jul 2016 05:22:08 GMT

OR statement in Set Analysis is represented as "+" sign.

=Count({<Maths={'>=90'}>+<Chem={'>=90'}>}Sname)

The syntax Count({<Condition1> + <Condition2>} FieldName).

Re: Set Analysis OR Condition

sravanthialuval — Tue, 26 Jul 2016 05:41:53 GMT

Try like this,

The no of students who secured 90% in either Maths or Physics.

Re: Set Analysis OR Condition

manojkulkarni — Tue, 26 Jul 2016 05:53:45 GMT

Thanks Arul,

I am using the same expression in original application it is not working, but it works with sample set of data. Need to check weird behavior of expression.

Re: Set Analysis OR Condition

arulsettu — Tue, 26 Jul 2016 05:55:41 GMT

check the expression