Blank in Inline Listbox

[Yuhka]

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!

[tresesco]

Just add the below line before load statement:

SET NullInterpret='';

[haribabugv · Accepted solution]

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

[Yuhka]

Thank you for your big help!

It worked perfectly!