Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
kaiiqquesilva
Contributor
Contributor

Desconsiderar data sem prenchimento

Boa noite.

Tenho uma tabela onde tem uma coluna "Dados de atendimento" essa coluna tem algumas linhas preenchidas com dados e algumas linhas NULL , Quando eu faço uma expressão = count ([Data de atendimento]) ele está contando todas as linhas, gostaria que ele me retornasse apenas a quantidade das linhas que tem data.

Obrigado.

1 Solution

Accepted Solutions
Chip_Matejowsky
Support
Support

Ola @kaiiqquesilva,

You're looking to suppress null values from your expression? If so, this question has been answered a few times previously in Community.  Have a look at the below threads:

https://community.qlik.com/t5/QlikView-App-Dev/How-to-Exclude-Null-Values-from-Calculated-Expression...

https://community.qlik.com/t5/QlikView-App-Dev/Hiding-or-Suppressing-the-Null-Empty-Values/td-p/1341...

https://community.qlik.com/t5/QlikView-App-Dev/Suppressing-null-values-expression/td-p/1254735

Hope this helps!

Best Regards

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

1 Reply
Chip_Matejowsky
Support
Support

Ola @kaiiqquesilva,

You're looking to suppress null values from your expression? If so, this question has been answered a few times previously in Community.  Have a look at the below threads:

https://community.qlik.com/t5/QlikView-App-Dev/How-to-Exclude-Null-Values-from-Calculated-Expression...

https://community.qlik.com/t5/QlikView-App-Dev/Hiding-or-Suppressing-the-Null-Empty-Values/td-p/1341...

https://community.qlik.com/t5/QlikView-App-Dev/Suppressing-null-values-expression/td-p/1254735

Hope this helps!

Best Regards

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!