topic Product structure in QlikView

Product structure

boryspower — Thu, 11 Feb 2010 23:11:00 GMT

Hello,

I have a file with simple product structure (please look below) and I want to make an multi level structure from it.

Example of what I have:

item component quantity_in_item other_fields

xx1 yy1 1

xx2 xx3 1

xx2 yy2 2

yy1 zz1 1

yy1 oo2 3

yy2 yy1 2

yy2 oo1 1

The quantity says that for example that one piece of yy1 consists of one zz1 and three pieces of oo2... but I think it doesn't matter for this example...

and what I want to present is:

HI_level level-1 level-2 level-3

xx2 xx3

xx2 yy2 oo2

xx2 yy2 yy1 zz1

xx2 yy2 yy1 oo2

end so on....

So I'd like to get like tree structure from a "flat" file... is it possible? Any ideas how it could be solved?

Thank You for Your time in advance.

Borys Power

Product structure

johnw — Thu, 11 Feb 2010 23:34:09 GMT

Have a look at hierarchy loads in the help text or reference manual. That's exactly what they do.

Product structure

boryspower — Fri, 12 Feb 2010 00:05:22 GMT

but as I understand You I have to have sone ParentItemName field?

Product structure

johnw — Fri, 12 Feb 2010 00:10:10 GMT

The parent of "component" is "item". That's your parent child relationship unless I'm misunderstanding your data?

Product structure

boryspower — Fri, 12 Feb 2010 00:16:10 GMT

You are right, sorry 🙂

Thank You!

Product structure

boryspower — Fri, 12 Feb 2010 08:42:35 GMT

Hi again,

One more thing - when I try to run:

I get error:

What am I doing wrong??

Product structure

johnw — Tue, 16 Feb 2010 21:39:32 GMT

From the help text:

ParentName is a string used to name the new ParentName field. If omitted, this field will not be created.

As I read that, specifying anything there is telling it to create a NEW field with the given string as the name. Not sure why it doesn't require single quotes around the string for clarity, but QlikView often lets you not use them. Anyway, you're both loading a field ParentName, and asking QlikView to create a new field, ParentName. Thus the error.

Product structure

boryspower — Fri, 19 Feb 2010 09:01:58 GMT

Hi,

It was a bit confusing but finally I understand it 🙂 Thank You!