List Box

[panipat1990]

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

[vinieme12]

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

];

[panipat1990]

Dear Vineeth,

Can You share me qvw.

[Anonymous]

Hi Gourav,

Please find attached file.

Hope it helps!

[panipat1990]

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

[vinieme12 · Accepted solution]

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

[Anonymous]

Add this inline table to your script. It is enough

[Anonymous]

Hi,

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

Hope it helps!!