topic Re: Excluding Blanks from the field in QlikView

Excluding Blanks from the field

Wed, 26 Feb 2014 18:14:25 GMT

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.

Re: Excluding Blanks from the field

chiru_thota — Wed, 26 Feb 2014 18:25:39 GMT

can you try this ?

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

Re: Excluding Blanks from the field

Wed, 26 Feb 2014 18:27:37 GMT

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

Re: Excluding Blanks from the field

jerem1234 — Wed, 26 Feb 2014 18:28:16 GMT

Maybe:

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

Hope this helps!

Re: Excluding Blanks from the field

Wed, 26 Feb 2014 18:30:05 GMT

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 <> ' ';

Re: Excluding Blanks from the field

dhanu_today — Wed, 26 Feb 2014 18:36:59 GMT

May be like this to remove the blank.

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

Re: Excluding Blanks from the field

maxgro — Wed, 26 Feb 2014 20:19:29 GMT

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

Re: Excluding Blanks from the field

Clever_Anjos — Wed, 26 Feb 2014 20:34:28 GMT

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

Re: Excluding Blanks from the field

Thu, 27 Feb 2014 10:45:02 GMT

Did not work in this case

Re: Excluding Blanks from the field

Thu, 27 Feb 2014 10:45:16 GMT

also did not work

Re: Excluding Blanks from the field

Thu, 27 Feb 2014 10:46:39 GMT

this did work!

Re: Excluding Blanks from the field

Thu, 27 Feb 2014 10:48:00 GMT

Did not work

Re: Excluding Blanks from the field

Thu, 27 Feb 2014 10:48:46 GMT

did not work 😕

Re: Excluding Blanks from the field

er_mohit — Thu, 27 Feb 2014 10:49:27 GMT

try this in your text object

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