topic Simple listbox problem in QlikView

Simple listbox problem

nicktodd — Thu, 07 Feb 2019 09:43:57 GMT

A simple problem that's defeating me. In the attached example I want a listbox to show the number of students who have a particular code and the number of students who don't have that code.

For example, if I'm interested in Code B I want Yes = 3 and No = 4.

I think the solution must be obvious but I'm not seeing it!

Thanks

Re: Simple listbox problem

mdmukramali — Thu, 07 Feb 2019 10:18:35 GMT

Hi,
Field Expression:
=if(code='B','Yes','No')

Expression:
=IF(code<>'B', Count({<student=E({1<code={B}>})>}DISTINCT student),Count({<student=P({1<code={B}>})>}DISTINCT student))

Re: Simple listbox problem

nicktodd — Thu, 07 Feb 2019 10:22:10 GMT

Super!

I was forgetting about the powerful P and E functions.

many thanks