Displaying specific value from the field

[#1]

I have a field called "PAYMENT_STATUS_FLAG" and what i want to do is to only display the Count of the 'N".

I tried this expression

I'm supposed to get this value

However my expression does'nt work and instead i get the count for the whole "PAYMENT_STATUS_FLAG" .

I wonder if anyone could help me out, Thanks!

[adamdavi3s]

count({<PAYMENT_STATUS_FLAG={'N'}>}PAYMENT_STATUS_FLAG)

sum(if(PAYMENT_STATUS_FLAG='N',1,0))

[Anonymous]

Try

count({<PAYMENT_STATUS_FLAG={'N'}>}PAYMENT_STATUS_FLAG)

Hope this helps!

[#4]

Hi Adam  the first statement alone helped solve the problem. Thanks so much!

[#5]

Hey qlikdeez

I'm able to get the desired value, Thank you so much!:)

[sunny_talwar]

please close the thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny