Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Karahs
Partner - Creator
Partner - Creator

QS- Blank Value

Hello everyone,

          So my question is i have hightlighted some words in the below code, i want to print the blank spaces count. I have blank spaces in my excel n want to remove their count but not getting their count. Am i using the right way to do so?

[Sheet1$]:

LOAD

[DOCUMENT NO],

  [DOCUMENT DATE],

  [DOCUMENT TYPE],

  [DOCUMENT STATE],

  [ACTIVITY DATE],

  [FILE FORMAT],

  [CLIENT CODE],

  [CLIENT NAME],

  [CLIENT EMAIL],

  [ALT EMAIL],

  [BCC EMAIL],

  [LOGIN USERNAME],

  [SOURCE FILE],

  [EXCHANGE],

  [IntDmatLogID],

  [ClientType],

    if(BO_Reason='General Bounce'or BO_Reason=' ' or BO_Reason='Soft Bounce - General','Soft Bounce','Hard Bounce') as dd,

  [BO_Reason]

FROM []

(biff, embedded labels, table is Sheet1$);

Table2:

Load*Inline

[

ClientType,ClientTypeNew

1,'ECN'

2,'Non-ECN'

];

Table3:

Load*Inline

[

BO_Reason,Bounce_Category

'General Bounce','Soft Bounce'

'    ','Soft Bounce'

'Hard Bounce','Hard Bounce'

'Soft Bounce - General','Soft Bounce'

Thanks& Regards,

Kshitija

1 Reply
sunny_talwar

Don't see where are you doing the count? Can you elaborate a little please

UPDATE: To handle blank space, I would usually use Len(Trim(BO_Reason)) = 0 as the condition instead of BO_Reason = ' '