Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
sonu8072
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

Thanks,

Aditya Mishra

1 Reply
Gysbert_Wassenaar

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