topic Re: Help to build a table by script in QlikView

Help to build a table by script

Thu, 27 Sep 2012 10:04:53 GMT

Hi guys,

I need help.

I have a table with two fields "ID" and "CHILD".

For instance.

ID CHILD

1 2

2 3

3 147

147 149

236 237

237 242

242

344 345

I'd like to build another table like that:

LIV1 LIV2 LIV3 LIV4 LIV5 LIV6 LIV7 ... LIV12

1 2 3 147 149

236 237 242

344 345

ID and CHILD It's like a tree. I have to follow every main branch of the tree.

hope it's clear.

I attach a file with the initial table.

Any idea to solve my problem?

Best regards

Giampiero

Re: Help to build a table by script

swuehl — Thu, 27 Sep 2012 10:27:39 GMT

You can look into the HIERACHY LOAD prefix, maybe like

HIERARCHY(CHILD, ID, ID_Name) LOAD ID_Name,

ID,

PARENT,

CHILD,

NEXTN

FROM

[table.xls]

(biff, embedded labels, table is [initial table$]);

Re: Help to build a table by script

Thu, 27 Sep 2012 10:39:43 GMT

Hi,

thanks for your reply.

I already tried with HIERARCHY but unfortunately it doesn't seem to help me.

It doesn't build the hierarchy like I need to.

Any other idea

Many thanks

regards

Giampiero

Re: Help to build a table by script

swuehl — Thu, 27 Sep 2012 11:40:16 GMT

As far as I remember, it should return a table like you requested above, but I think it will eventually return more records than you need, so you may want to remove some of them afterwards. That means, the table will create one record per input record, including all parents (complete path to ID).

HIERARCHY (ID, PARENT, ID_Name )

LOAD ID as ID_Name,

ID,

PARENT

FROM

[table.xls]

(biff, embedded labels, table is [initial table$]);

Re: Help to build a table by script

Thu, 27 Sep 2012 12:41:46 GMT

Hi,

I did exactly the same (I attach my file).

Unfortunately the hierarchy is not readable.

I mean there are lots of rows in my pivot table that are not useful for me and don't allow to understand the hierarchy.

Any idea about it.

Many thanks

Giampiero

Re: Help to build a table by script

Thu, 27 Sep 2012 12:43:10 GMT

Sorry the attach file 🙂

Re: Help to build a table by script

swuehl — Thu, 27 Sep 2012 14:00:58 GMT

This should at least create the hierarchy tree view in your list box.

Hope this helps,

Stefan

Re: Help to build a table by script

Mon, 01 Oct 2012 07:48:34 GMT

Hi Stefan,

THANK YOU SO MUCH.

It works.

Giampiero