Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 |
];
Dear Vineeth,
Can You share me qvw.
Hi Gourav,
Please find attached file.
Hope it helps!
So i will have to left join to inline line table to my main table on the basis of division..
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
Add this inline table to your script. It is enough
Hi,
Please find attached file. Use New Division for List box.
Hope it helps!!