Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Multiple Dimension In to Single Dimesion

Hello Qlik Expert,

I My Data Set I have 2 Dimesion As Region And City.

I have to Display New Dimesion As Region Followed By City.

Input:

RegionCity

 

Output:

Region
City

 

I have Uploaded the Input data and Output Data In Excel File.

Thanx In Advance..!!!

Labels (3)
1 Reply
Highlighted
Support
Support

hi ,

//something like : 

Table1:
Load
City as Output


FROM [lib://Sample/community.xlsx]
(ooxml, embedded labels, header is 2 lines, table is Sheet1);


Load
Region as Output


FROM [lib://Sample/community.xlsx]
(ooxml, embedded labels, header is 2 lines, table is Sheet1);

 

 

Regards,

Akshesh