Count if

[#1]

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

[prma7799]

Try like this

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

[#3]

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".

[vinieme12]

uncheck "Supress Zero values" in PResentation tab

[vinieme12 · Accepted solution]

or maybe you just need this

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

[devarasu07]

Hi,

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

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

[Anil_Babu_Samineni]

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

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

[vinieme12]

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

[qlikview979]

Hi,

Are you expecting like this

regards

[prma7799]

Like this ?