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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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!