Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Just add the below line before load statement:
SET NullInterpret='';
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
Thank you for your big help!
It worked perfectly!