topic Re: Pivot tabel issue in QlikView

Pivot tabel issue

jduluc12 — Wed, 25 Oct 2017 11:56:05 GMT

Hi,

My data set looks like this

Main:

ID	Name
1	ABC
2	DEF
3	GHI
4	JKL

Aux:

ID	ID-1
1	4
2	3
3	2
4	1

Now I need to build a pivot like this:

ID	ID-1	Name
1	4	JKL
2	3	GHI
3	2	DEF
4	1	ABC

is it possible?

Thanks,

Jean

Re: Pivot tabel issue

prma7799 — Wed, 25 Oct 2017 12:06:19 GMT

Like this??

Main:

LOAD ID as IDD,

Name

FROM

[279199.xlsx]

(ooxml, embedded labels, table is Sheet1);

Right join (Main)

Aux:

LOAD ID ,

[ID-1] as IDD

FROM

[279199.xlsx]

(ooxml, embedded labels, table is Sheet2);

Re: Pivot tabel issue

jduluc12 — Wed, 25 Oct 2017 12:09:25 GMT

Thanks P M but i can not change the load script.

Re: Pivot tabel issue

prma7799 — Wed, 25 Oct 2017 12:10:22 GMT

You want to achieve this in front end only ???

Re: Pivot tabel issue

jduluc12 — Wed, 25 Oct 2017 12:16:45 GMT

yes

Re: Pivot tabel issue

tresB — Wed, 25 Oct 2017 12:48:43 GMT

Try like:

Above( ID,-NoOfRows()+ 2*RowNo()-1)

Above( Name,-NoOfRows()+ 2*RowNo()-1)

Re: Pivot tabel issue

prma7799 — Wed, 25 Oct 2017 12:51:57 GMT

Hi tresesco‌,

Can you please explain that how you apply logic for this and how this functions will works.

Thanks & Regards

Re: Pivot tabel issue

tresB — Wed, 25 Oct 2017 12:59:18 GMT

Above() with negative offset works like below(). Rest is simple math and row reference idea.