topic Re: How to remove a blank value from a List? in QlikView

How to remove a blank value from a List?

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I created a list of Months in my project, where it is displayed a blank check box, as you can see in the print screen below:

I looked into my data base an there is no blank fields, i mean, all fields are fulfilled in the table.

Someone know if it is possible to remove that blank check box from my List?

Regards,

Re: How to remove an blank value from a List?

jonathandienst — Fri, 01 Apr 2016 13:16:27 GMT

Somehow the blank field is being created in your load script and the problem (if it is a problem) should be fixed there. If the blank is not coming from your source, then it could be something like a conversion or a join that is not working properly.

You could suppress it in the list from the front end, but if I were you, I would make sure I understood where it was coming from before suppressing it. But the best is to fix the script.

Re: How to remove a blank value from a List?

sunny_talwar — Fri, 01 Apr 2016 21:47:36 GMT

You can fix this in the script:

LOAD fieldNames,

If(Len(Trim(Mes)) > 0, Mes) as Mes

FROM ....

Re: How to remove a blank value from a List?

Mon, 04 Apr 2016 13:50:57 GMT

Thanks Sunny,

This if statement in the script fixed the blank filed issue.

Have a nice day!