topic Re: Count expression excluding values in QlikView

Count expression excluding values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Count expression excluding values

Thu, 29 Sep 2016 17:00:44 GMT

did u use this code

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

if u used different code please let me know

Re: Count expression excluding values

Thu, 29 Sep 2016 17:05:33 GMT

corrected code

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

Re: Count expression excluding values

Anonymous — Thu, 29 Sep 2016 17:16:21 GMT

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