Straight table Custom dimension and a Value List

[techvarun]

Hello Qlixperts,

I have a straight table with two dimensions

Source = 'H'

KPI = ValueList('a','b','c','d','e','f','g','h','i','j','k','l','m')

So my Dimensions looks like below

Source	KPI
H	a
H	b
H	c
H	d
H	e
H	f
H	g
H	h
H	i
H	j
H	k
H	l
H	m

Now i want to achieve the dimensions as below

Source	KPI
H	a
H	b
H	c
H	d
H	e
H	f
H	g
H/H	h
H	i
I	j
H	k
I/H	l
H/I	m

Thanks a lot in advance.

I have attached a sample qvw

[Anil_Babu_Samineni]

May be this?

=Pick(Match(KPI,'h','i','m')+1,Source,'H/H','I/H','H/I')

[techvarun]

Hi Anil,

Since the Fields Source and KPI is not from data model the pick and match is not working as expected

[vinieme12]

See this post

Partial Sums in straight table | Custom Labels in Pivot SubTotals

[Kushal_Chawda]

what is logic to get the dimension value as expected?

[techvarun]

I just attached a sample qlikview file.

[techvarun]

Please check the sample attached

[tresesco]

I am not sure about the utility of this. However, I have tried to get the output (with a not-so meaningful way though).

Check if this helps.

[techvarun]

Thanks Tresesco for the swift reply.

This is to convert some excel reports into qlikview without affecting the table structure.

is it possible to create the columns in dimension itself? the attached solution is not so friendly with my table structure

Thanks,

Varun

[omkarvamsi]

you can achieve this through inline load