Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excluding Blanks from the field

Hi, I am using this qvw that is counting the field "Name", but i want to exclude the ones that the field "EEJ_A_C_Involved" is in blank. How do I take that off? I tried the simple formulas, didn't work... Does someone have a clue of that?

thank you.

13 Replies
Not applicable
Author

this did work!

Not applicable
Author

Did not work

Not applicable
Author

did not work 😕

er_mohit
Master II
Master II

try this in your text object

=count(if( EEJ_A_C_Involved__c<>'', EEJ_A_C_Involved__c))