Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

Tags (1)
1 Solution

Accepted Solutions
jerem1234
Valued Contributor II

Re: Excluding Blanks from the field

Maybe:

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

Hope this helps!

13 Replies
chiru_thota
Valued Contributor

Re: Excluding Blanks from the field

can you try this ?

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

Not applicable

Re: Excluding Blanks from the field

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

jerem1234
Valued Contributor II

Re: Excluding Blanks from the field

Maybe:

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

Hope this helps!

Not applicable

Re: Excluding Blanks from the field

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
New Contributor III

Re: Excluding Blanks from the field

May be like this to remove the blank.

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

MVP
MVP

Re: Excluding Blanks from the field

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

Employee
Employee

Re: Excluding Blanks from the field

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

Not applicable

Re: Excluding Blanks from the field

Did not work in this case

Not applicable

Re: Excluding Blanks from the field

also did not work

Community Browser