Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Multiple dimension in single column

Hii, 

 

Anyone help me with this:

I have a input Region & City.

Input.PNG

and output should be as below in pivot table:

output.PNG

 

 

 

 

6 Replies
Highlighted

Why do you need them in one column? If its just for appearance, you could use indent mode (Styles tab)  in the pivot and remove vertical lines between cells. Set up any partial totals before switching to indent mode.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Contributor III
Contributor III

Thanks for the suggestion.

So, this is the input:

Capture22.PNG

 

and the output should be:

Capture233.PNG

Highlighted
Specialist
Specialist

Is there any special requirement due to which you are not using PIVOT Table?
Highlighted
Contributor III
Contributor III

I am not able to build this pivot table. I want to add Region and city in single column.

Pleas someone help me on this

Highlighted
Specialist II
Specialist II

Following the comments Jonty gave i tried to set something with the Data given, Please check if the attached works

Highlighted
Specialist
Specialist

Anushree,
Can you put snapshot of these adjustments? I cannot open qvw.