topic Re: Count if in QlikView

Count if

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to count the column "workerid" where the field isapplies='appliead' else i want to show the value "0"

i have the table:

WorkerID	IsApplied	Applied Job Count	the result I want
4202	Applied	2	2
24875	Not Applied	1	0
8796	Not Applied	1	0
8745	Not Applied	1	0

i have the folowing formula

count({<IsApplied-= {"=if((Not Applied"}>} WorkerID_WorkerDetails)

Which shows the result shown in the column "Applied Job Count" in the table above

Thanks in advance

Re: Count if

prma7799 — Tue, 20 Jun 2017 09:30:35 GMT

Try like this

=count({<IsApplied -= {"Not Applied"}>}WorkerID)

Re: Count if

Tue, 20 Jun 2017 09:40:39 GMT

Now I get the result

WorkerID	IsApplied	Applied Job Count
4202	Applied	2

worker that did not apply is not shown in the table,

the result i want,is to show also the workers who did not apply, with the value "0".

Re: Count if

vinieme12 — Tue, 20 Jun 2017 09:44:51 GMT

uncheck "Supress Zero values" in PResentation tab

Re: Count if

vinieme12 — Tue, 20 Jun 2017 09:46:11 GMT

or maybe you just need this

=if(IsApplied ='Applied',[Applied Job Count],0)

Re: Count if

devarasu07 — Tue, 20 Jun 2017 10:04:58 GMT

Hi,

Try to uncheck "Suppress Zero-Values" in the Presentation page then it should work

=if(IsApplied ='Applied',Applied_Job_Count,0)

Re: Count if

Anil_Babu_Samineni — Tue, 20 Jun 2017 10:05:31 GMT

Is this you are expecting? Added Sum over expression from Vinit

Sum(If(IsApplied = 'Applied', [Applied Job Count],0))

Re: Count if

vinieme12 — Tue, 20 Jun 2017 10:09:05 GMT

Just use the expression posted above by P M and uncheck Supress Zero value, that is all you need

Re: Count if

qlikview979 — Tue, 20 Jun 2017 10:13:34 GMT

Hi,

Are you expecting like this

regards

Re: Count if

prma7799 — Tue, 20 Jun 2017 10:14:40 GMT

Like this ?

Re: Count if

Tue, 20 Jun 2017 10:23:18 GMT

Thank you all !!

Re: Count if

prma7799 — Tue, 20 Jun 2017 10:24:08 GMT