topic Need count who attended only Maths in QlikView

Need count who attended only Maths

varunvarma — Sat, 16 Nov 2024 04:39:08 GMT

Hi Team,

I need to count of Students who attended only Maths. Please find the sample data below.

load * inline [

StudentId,Subject

1, Maths

1, Physics

2, Maths

2, Chemistry

3, Physics

3, Maths

4, Maths

5, Chemistry

6, Maths

]

Result : Count of StudentId who attended only Maths - ie 2.

I need to achieve this in text object, only with set Analysis or If condition. No change in data model.

please let me know if you got any idea. Thanks in advance.

Re: Need count who attended only Maths

Anil_Babu_Samineni — Sun, 27 Jan 2019 02:19:12 GMT

Try this?
Count({<Subject = {'Maths'}>} StudentId)

Re: Need count who attended only Maths

varunvarma — Sun, 27 Jan 2019 02:25:55 GMT

Hi, I need only count of StudentId who attended only Maths. Ie result should be 2.

StudentId : 4 and 6. Only these 2 students attended only Maths.

Re: Need count who attended only Maths

rubenmarin — Sun, 27 Jan 2019 10:58:45 GMT

Hi, you can try this expression:
=Count({<Subject = {'Maths'}, StudentId={"=Count(Distinct Subject)=1"}>} StudentId)

Re: Need count who attended only Maths

varunvarma — Sun, 27 Jan 2019 13:25:09 GMT

@rubenmarin Thanks for the support. It’s working fine.

But 1 doubt, how count of distinct subject are aggregated by student only. In case if I have multiple columns then how it behaves.

Re: Need count who attended only Maths

rubenmarin — Tue, 29 Jan 2019 07:54:30 GMT

Hi, I don't underestand the problem with multiple columns, can you expand the question with sample data?

The expresion works with 2 conditions: having Maths as subject and having only one subject, so this only subject has to be Maths to be counted.