Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
panipat1990
Contributor II

List Box

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

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: List Box

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

7 Replies
vinieme12
Esteemed Contributor II

Re: List Box

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
Contributor II

Re: List Box

Dear Vineeth,

Can You share me qvw.

qlikviewnovice
Valued Contributor II

Re: List Box

Hi Gourav,

Please find attached file.

Hope it helps!

panipat1990
Contributor II

Re: List Box

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

vinieme12
Esteemed Contributor II

Re: List Box

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

qlikviewnovice
Valued Contributor II

Re: List Box

Add this inline table to your script. It is enough

qlikviewnovice
Valued Contributor II

Re: List Box

Hi,

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

Hope it helps!!

Community Browser