Excluding Blanks from the field

[#1]

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.

[chiru_thota]

can you try this ?

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

[#3]

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

[jerem1234 · Accepted solution]

Maybe:

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

Hope this helps!

[#5]

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]

May be like this to remove the blank.

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

[maxgro]

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]

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

[#9]

Did not work in this case

[#10]

also did not work