https://community.qlik.com/t5/QlikView/Convert-Straight-Table-to-List-for-Excel-Name-Manger-handling/m-p/1524981#M748018 <P>This is only possible if you can remodel your data like in the attached example. You probably don't want to because you're creating extra values in your country and cities dimensions that will mess up your other charts unless you take extra measures to prevent that.</P> Sun, 30 Dec 2018 07:47:36 GMT Gysbert_Wassenaar 2018-12-30T07:47:36Z https://community.qlik.com/t5/QlikView/Convert-Straight-Table-to-List-for-Excel-Name-Manger-handling/m-p/1524947#M748016 <P>Hi QV Experts!</P><P>Appreciate your help on a problem is face often. I have an existing straight table as below &amp; need to convert the same into a particular form [so that my Excel Name Manager can handle for dependent drop downs].</P><P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="QV Question.PNG" style="width: 783px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/2786iB011AA4F8394EBA2/image-size/large?v=v2&amp;px=999" role="button" title="QV Question.PNG" alt="QV Question.PNG" /></span></P><P>Thanks,</P><P>Aditya Mishra</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Convert-Straight-Table-to-List-for-Excel-Name-Manger-handling/m-p/1524947#M748016 sonu8072 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Convert-Straight-Table-to-List-for-Excel-Name-Manger-handling/m-p/1524981#M748018 <P>This is only possible if you can remodel your data like in the attached example. You probably don't want to because you're creating extra values in your country and cities dimensions that will mess up your other charts unless you take extra measures to prevent that.</P> Sun, 30 Dec 2018 07:47:36 GMT https://community.qlik.com/t5/QlikView/Convert-Straight-Table-to-List-for-Excel-Name-Manger-handling/m-p/1524981#M748018 Gysbert_Wassenaar 2018-12-30T07:47:36Z