topic Re: Create a Dimension with indents in QlikView

Create a Dimension with indents

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I got a request to create a dimension in below format. I know about the Tree view in List box but that is not what I am looking for. I want to use the output dimension as a Dimension in a Straight table with similar view.

Input Data: (Region - EU, Territory - Benelux/Central Europe, Country - Belgium/Netherlands/Germany etc)

Region-Territory-Country

EU-Benelux

EU-Benelux-Belgium

EU-Benelux-Netherlands

EU-Central Europe

EU-Central Europe-Germany

EU-Central Europe-Poland

Output required:

Region-Territory-Country

Benelux

Belgium

Netherlands

Central Europe

Germany

Poland

Thanks

Karthik

Re: Create a Dimension with indents

Frank_Hartmann — Fri, 12 Oct 2018 12:46:39 GMT

like this?

Re: Create a Dimension with indents

jonathandienst — Fri, 12 Oct 2018 12:58:01 GMT

You can get this type of view in a pivot table using Style | Indent Mode. This assumes that he data models has associations between the header levels. If you have a single field, you will some load logic to split into 3 fields.

Or you can prefix the name with spaces in a straight table. But you will not able expand or collapse like in a pivot. For example a calculated dimension like:

=Repeat(' ', SubStringCount([Region-Territory-Country], '-') & [Region-Territory-Country]

Re: Create a Dimension with indents

jonathandienst — Fri, 12 Oct 2018 13:01:18 GMT

=Repeat(' ', SubStringCount([Region-Territory-Country], '-')) &

SubString([Region-Territory-Country], '-', SubStringCount([Region-Territory-Country], '-')

Re: Create a Dimension with indents

Anonymous — Fri, 12 Oct 2018 13:13:53 GMT

Not exactly.

I know this Tree view option. Let me try the solution given by Jonathan

Re: Create a Dimension with indents

sudeepkm — Fri, 12 Oct 2018 14:28:16 GMT

slight modification to Jonathan's expression.

=Repeat(' ', SubStringCount([Region-Territory-Country], '-')) & SubField([Region-Territory-Country],'-',SubStringCount([Region-Territory-Country], '-')+1)

For below data:

Region-Territory-Country

EU-Benelux

EU-Benelux-Belgium

EU-Benelux-Netherlands

EU-Central Europe

EU-Central Europe-Germany

EU-Central Europe-Poland

USA

USA-NY

USA-NY-NewYork

USA-NY-Buffalo

USA-CT

USA-CT-Hartford

USA-CT-Berlin

output:

Re: Create a Dimension with indents

Anonymous — Fri, 12 Oct 2018 15:14:47 GMT

Yes, it worked. Almost there

Can we show EU in the middle and Benelux without indent and Beglium with Indent.

Like below:

Benelux

Belgium

Netherlands

Re: Create a Dimension with indents

sudeepkm — Fri, 12 Oct 2018 15:39:29 GMT

sure. This can be done in few ways. One way is given below.

Please follow these steps.

Create a variable as below.

vlen

=Max(aggr(len([Region-Territory-Country]),[Region-Territory-Country]))

Then change the Dimension as

=if(SubStringCount([Region-Territory-Country], '-')=0,

Repeat(' ',Round(vlen/4))&[Region-Territory-Country],

Repeat(' ', SubStringCount([Region-Territory-Country], '-')) & SubField([Region-Territory-Country],'-',SubStringCount([Region-Territory-Country], '-')+1))

Re: Create a Dimension with indents

sudeepkm — Fri, 12 Oct 2018 16:14:25 GMT

also instead of ' ' in Repeat function it is better to use chr(32) for space.

Re: Create a Dimension with indents

Anonymous — Fri, 12 Oct 2018 17:20:20 GMT

Countries are randomly segregated into different Territories in my file.

Am I missing any sorting

Re: Create a Dimension with indents

sudeepkm — Fri, 12 Oct 2018 17:31:04 GMT

Sorted by Region-Territory-Country field.

I'm using an inline load like below

Region-Territory-Country

EU-Benelux

EU-Benelux-Belgium

EU-Benelux-Netherlands

EU-Central Europe

EU-Central Europe-Germany

EU-Central Europe-Poland

USA

USA-NY

USA-NY-NewYork

USA-NY-Buffalo

USA-CT

USA-CT-Hartford

USA-CT-Berlin