Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

Maybe:

count({<EEJ_A_C_Involved__c = {'=len(EEJ_A_C_Involved__c)<>0'}>}distinct Name)

Hope this helps!

View solution in original post

13 Replies
chiru_thota
Specialist
Specialist

can you try this ?

=if(len(EEJ_A_C_Involved__c) >0,count(Name),0)

Not applicable
Author

=if(EEJ_A_C_Involved__c <> ' ' or IsNull(EEJ_A_C_Involved__c), Count(Name))

jerem1234
Specialist II
Specialist II

Maybe:

count({<EEJ_A_C_Involved__c = {'=len(EEJ_A_C_Involved__c)<>0'}>}distinct Name)

Hope this helps!

Not applicable
Author

Hi Julio ,

Try the script given below

LOAD

     Name,

     CreatedDate,

     Converted_P3E_Scale__c,

     EEJ_A_C_Involved__c,

     A_C_Serial_Number_Manual_Entry__c,

     Service_Center_Manual_Entry__c

FROM

[\\Sjkqa31\qlikview\Desenvolvimento\SC Network Cockpit QVDs\Feedback.qvd]

(qvd) Where EEJ_A_C_Involved__c <> ' ';

dhanu_today
Creator
Creator

May be like this to remove the blank.

=if(not wildmatch(EEJ_A_C_Involved__c,''),EEJ_A_C_Involved__c).

maxgro
MVP
MVP

select blank in listbox EE.... and then right click --> select excluded

other ways

in expression (add a distinct if you need it) I think

=count (if (len(trim(EEJ_A_C_Involved__c))>0, Name))

or with set analysis

=count ({$ <EEJ_A_C_Involved__c-={''}>} Name)

in script to exclude records

WHERE len(trim(EEJ_A_C_Involved__c))>0

Clever_Anjos
Employee
Employee

=count({<EEJ_A_C_Involved__c=EEJ_A_C_Involved__c-{''}>}Name)

Not applicable
Author

Did not work in this case

Not applicable
Author

also did not work