Count expression excluding values

[Anonymous]

Hi,

I will like to create a bar's dashboard excluding some data. For example, I have multiple records with different statuses (Open, Pending, working, Closed). I will like that the dashboard perform a count of IDs where the status = 'Open'.

I have tried adding a conditional in the expressions tab like Status ='Open', I have also tried to modify the definition of the count adding the if part, but none of them worked.

What is the correct way to set an expression that count the ID where the Status is equal to 'Open'.

Thank you in advanced for your help.

[#2]

did u use this code

= count({<status={Open}>} ID)

if u used different code please let me know

[#3 · Accepted solution]

corrected code

= count({<status={'Open'}>} ID)

[Anonymous]

THIS WORKED CORRECTLY!!!!! THANK YOU!!!!!

Can you please take a look at this request and see if you know something similar that I can use in this other question:

https://community.qlik.com/message/1132095?et=watches.email.thread#1132095

This is almost the same but instead of a count I need to display only the last 6 months