topic Empty Strings - How to filter them out in QlikView

Empty Strings - How to filter them out

Fri, 18 Nov 2011 13:22:23 GMT

I have a char field that either has a 10 digit number in it i.e. (0000658978) or it is empty. After loading the table and then when I try and do a resindent load on this field where it's not equal to an empty string it does not weed out the lines where this field is empty. Can anyone assist on the script to deal with this situation? Thanks, Sean

Empty Strings - How to filter them out

Fri, 18 Nov 2011 13:32:31 GMT

When you load this field into a list box does this empty string appear as a selection option?

Empty Strings - How to filter them out

ToniKautto — Fri, 18 Nov 2011 14:02:01 GMT

Sounds like you should get either blank strings or null values in your data. If this is the case you can filter on either or both conditions, for example by the principle below.

LOAD

RESIDENT TableName

WHERE not IsNull(F1) AND Len(F1) > 0;

Empty Strings - How to filter them out

Fri, 18 Nov 2011 14:06:37 GMT

In a list box it does not, but in a table I can select it and it will filter the table to show all lines where this field is empty.

Empty Strings - How to filter them out

Fri, 18 Nov 2011 14:06:52 GMT

Try:

WHERE len(trim(F1)) > 0

Regards,

Gordon

Empty Strings - How to filter them out

Fri, 18 Nov 2011 14:18:13 GMT

Hi,

While uploading the data go to "Enable Transformation Step" and in the Garbage Tab apply "Conditional Delete"

there you can delete as per you condition,

Empty Strings - How to filter them out

Fri, 18 Nov 2011 14:20:20 GMT

This did not work. I received the same results. I also tried a couple of iterations and that did not work as well.the script is:

INNER

JOIN (BillingLine)
Load Distinct
%KEY_VBRP,
[Sales deal_KNUMA_AG]

Resident BillingLine where not IsNull([Sales deal_KNUMA_AG]) and Len([Sales deal_KNUMA_AG]) >0;

Empty Strings - How to filter them out

Fri, 18 Nov 2011 14:21:11 GMT

Can you provide a sample?

Empty Strings - How to filter them out

Fri, 18 Nov 2011 14:32:34 GMT

Ah, that did the trick, thanks much.

Re: Empty Strings - How to filter them out

Fri, 18 Nov 2011 14:33:09 GMT

just check the attached excel file and the table