Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Maybe:
count({<EEJ_A_C_Involved__c = {'=len(EEJ_A_C_Involved__c)<>0'}>}distinct Name)
Hope this helps!
can you try this ?
=if(len(EEJ_A_C_Involved__c) >0,count(Name),0)
=if(EEJ_A_C_Involved__c <> ' ' or IsNull(EEJ_A_C_Involved__c), Count(Name))
Maybe:
count({<EEJ_A_C_Involved__c = {'=len(EEJ_A_C_Involved__c)<>0'}>}distinct Name)
Hope this helps!
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 <> ' ';
May be like this to remove the blank.
=if(not wildmatch(EEJ_A_C_Involved__c,''),EEJ_A_C_Involved__c).
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
=count({<EEJ_A_C_Involved__c=EEJ_A_C_Involved__c-{''}>}Name)
Did not work in this case
also did not work