topic Re: List Box in QlikView

List Box

panipat1990 — Mon, 26 Jan 2026 18:19:17 GMT

Hi Team,

i stuck a requirement. I Have a list box where 5 division. and i want to add one division Name Like EL...These are 5 division

Division

CORP

EWM

EDS

EBM

EAN

I want to New Fieldvalue EL..Actually EL Is the combination of All 5Field Value..How is Possible. Kindly Help me.For this i am sharing data

Re: List Box

vinieme12 — Wed, 28 Sep 2016 10:35:56 GMT

Create another inline table with EL value that links to all other Divisions and use the new Field for ListBox

LOAD * INLINE [

Display_Division,	Division
EL,	CORP
EL,	EWM
EL,	EDS
EL,	EBM
EL,	EAN
CORP,	CORP
EWM,	EWM
EDS,	EDS
EBM,	EBM
EAN,	EAN

];

Re: List Box

panipat1990 — Wed, 28 Sep 2016 10:41:24 GMT

Dear Vineeth,

Can You share me qvw.

Re: List Box

Anonymous — Wed, 28 Sep 2016 10:48:14 GMT

Hi Gourav,

Please find attached file.

Hope it helps!

Re: List Box

panipat1990 — Wed, 28 Sep 2016 10:52:20 GMT

So i will have to left join to inline line table to my main table on the basis of division..

Re: List Box

vinieme12 — Wed, 28 Sep 2016 10:56:38 GMT

LEft join only if you want to have this data in the same table , which will increase the size of your QVW app. preferable let it just be connection to you main table . But it depends if you data runs over million of rows which i don't think is the case in the given scenario

Press CTRL + T to see the how the main table connects to the mapping table

Re: List Box

Anonymous — Wed, 28 Sep 2016 10:57:47 GMT

Add this inline table to your script. It is enough

Re: List Box

Anonymous — Wed, 28 Sep 2016 11:02:37 GMT

Hi,

Please find attached file. Use New Division for List box.

Hope it helps!!