Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Convert Straight Table to List [for Excel Name Manger handling]

Hi QV Experts!

Appreciate your help on a problem is face often. I have an existing straight table as below & need to convert the same into a particular form [so that my Excel Name Manager can handle for dependent drop downs].

 QV Question.PNG


Aditya Mishra

1 Reply
MVP & Luminary
MVP & Luminary

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.

talk is cheap, supply exceeds demand