topic Re: Multiple dimension in single column in QlikView

Multiple dimension in single column

bharathkamath28 — Wed, 25 Nov 2020 16:16:04 GMT

Hii,

Anyone help me with this:

I have a input Region & City.

and output should be as below in pivot table:

Re: Multiple dimension in single column

jonathandienst — Tue, 26 Mar 2019 08:13:00 GMT

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.

Re: Multiple dimension in single column

bharathkamath28 — Tue, 26 Mar 2019 08:35:45 GMT

Thanks for the suggestion.

So, this is the input:

and the output should be:

Re: Multiple dimension in single column

Shubham_Deshmukh — Tue, 26 Mar 2019 09:37:57 GMT

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

Re: Multiple dimension in single column

bharathkamath28 — Tue, 26 Mar 2019 11:16:11 GMT

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

Re: Multiple dimension in single column

anushree1 — Tue, 26 Mar 2019 13:53:17 GMT

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

Re: Multiple dimension in single column

Shubham_Deshmukh — Wed, 27 Mar 2019 04:21:10 GMT

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