topic Re: Blank in Inline Listbox in QlikView

Blank in Inline Listbox

Yuhka — Sat, 16 Nov 2024 03:54:16 GMT

Hello guys, I'm new to qlikciew.

I have three lists and I would like to load them concat inline as belows.

===========================================================

LOAD * INLINE [
    Fruit_List_1A, Fruit_List_2A, Fruit_List_3A
    Apple, Apple, Apple
    Orange, Orange, Orange
    Banana, Banana,
    Grape, Grape,
    Blueberry, Blueberry,
    Cherry, Cherry,
    Peach, ,
    Strawberry, ,
    Pineapple, ,
    Lemon, ,
];

===========================================================

However, in case to load concat inline, there will be blank rows in listbox (as the rows marked in yellow).

I know it will be improved by loading without concat, but this time I need to load using concat inline.

Is there any way to hide blank rows when loading concat inline?

Thank you for your support!

Re: Blank in Inline Listbox

tresB — Wed, 10 Apr 2019 07:06:20 GMT

Just add the below line before load statement:

SET NullInterpret='';

Re: Blank in Inline Listbox

haribabugv — Wed, 10 Apr 2019 07:09:46 GMT

You can create an expression like this for a list box and then blank fields can be eliminated

if (Len(Fruit_List_2A) > 0, Fruit_List_2A)

See the attached file for clarity

Re: Blank in Inline Listbox

Yuhka — Wed, 10 Apr 2019 07:42:08 GMT

Thank you for your big help!

It worked perfectly!