topic Re: Pivot table count on condition in QlikView

Pivot table count on condition

userid128223 — Tue, 14 Feb 2017 04:09:47 GMT

I have following kind of table

School	Subject	Students	Grades
ABC	Math	ab	0
ABC	Math	ac	12
ABC	Math	ad	32
ABD	Math	ae	1
BB	English	uu	44
BB	English	ud	0
BB	English	ua	33

I want to create pivot table like below

School	Subject	Count with Grades > 0	Count with all grades
ABC	Math	3	4
BB	English	2	3

How can i achive above pivot tables.

Re: Pivot table count on condition

prat1507 — Tue, 14 Feb 2017 04:28:06 GMT

PFA the .qvw for your reference.

Regards

Pratyush

Re: Pivot table count on condition

jonathandienst — Tue, 14 Feb 2017 04:45:18 GMT

Simple set expression:

=Count({<Grades = {">0"}>} Students)

Re: Pivot table count on condition

userid128223 — Tue, 14 Feb 2017 05:00:06 GMT

Thanks to both of you.

Another quick question. In my pivot i am getting counts correctly however i have some blank data which is also getting count and i want to keep it that way. However i was wondering if i can label empty field as "BLANKS"

Re: Pivot table count on condition

prat1507 — Tue, 14 Feb 2017 05:02:44 GMT

Just add to your dimension where you're getting blank as if(Dimension='','BLANKS',Dimension)