topic Re: Straight table Custom dimension and a Value List in QlikView

Straight table Custom dimension and a Value List

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

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

Re: Straight table Custom dimension and a Value List

Anil_Babu_Samineni — Thu, 24 Aug 2017 05:49:09 GMT

May be this?

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

Re: Straight table Custom dimension and a Value List

techvarun — Thu, 24 Aug 2017 06:27:20 GMT

Hi Anil,

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

Re: Straight table Custom dimension and a Value List

vinieme12 — Thu, 24 Aug 2017 08:47:42 GMT

See this post

Partial Sums in straight table | Custom Labels in Pivot SubTotals

Re: Straight table Custom dimension and a Value List

Kushal_Chawda — Thu, 24 Aug 2017 09:18:33 GMT

what is logic to get the dimension value as expected?

Re: Straight table Custom dimension and a Value List

techvarun — Tue, 29 Aug 2017 07:59:44 GMT

I just attached a sample qlikview file.

Re: Straight table Custom dimension and a Value List

techvarun — Tue, 29 Aug 2017 08:42:28 GMT

Please check the sample attached

Re: Straight table Custom dimension and a Value List

tresB — Tue, 29 Aug 2017 09:13:27 GMT

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.

Re: Straight table Custom dimension and a Value List

techvarun — Tue, 29 Aug 2017 09:27:10 GMT

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

Re: Straight table Custom dimension and a Value List

omkarvamsi — Tue, 29 Aug 2017 09:31:29 GMT

you can achieve this through inline load

Re: Straight table Custom dimension and a Value List

tresB — Tue, 29 Aug 2017 09:42:59 GMT

I guess, from here you should better start thinking about creating an INLINE table with two fields in the script and create your chart accordingly using pick(match(... in expressions.