topic Re: Flat table in QlikView

Flat table

Wed, 11 Dec 2013 14:13:18 GMT

Hi All

Hope someone can assist me. I am trying to write a Qlikview dashboard that takes a multi level bill of material and makes it a flat bill of material. The ERP System that is currently in use is Syspro. The is the current table structure.

I need to put all the levels in one table with all linked to a parent.

Hope I make sense. And thanks to all for the awesome Community!

Re: Flat table

Wed, 11 Dec 2013 14:31:18 GMT

Please use the Left Join like below:

FLAT_TABLE:

LOAD LEVEL1,

PARENT,

LEV1_QTY

FROM LEV1_SOURE;

LEFT JOIN

LOAD LEVEL1, LEVEL2, LEV2_QTY FROM LEV2_SOURCE;

LEFT JOIN

LOAD LEVEL2, LEVEL3, LEV3_QTY FROM LEV3_SOURCE;

If your data sources are huge in size then use the ApplyMap (make sure the that values should be in distinct nature)

Re: Flat table

Tue, 14 Jan 2014 11:17:00 GMT

Thanks for this, but how would I make the items in the tables appear in one list box.

Regards

Varshan

Re: Flat table

Clever_Anjos — Tue, 14 Jan 2014 11:39:47 GMT

Right Click, "Select Fields", choose which fields you want

Re: Flat table

Tue, 14 Jan 2014 11:44:51 GMT

Hi Guys

Have a look at the list boxes on the attached picture. I have a level 1 and a level 2. What I need to for level 1 and level 2 to live on the same list box.

So all tiers of the Bill of material listed as a single tier.

Regards

Re: Flat table

Clever_Anjos — Tue, 14 Jan 2014 11:52:16 GMT

Create a field into your table using

Field1 & '/' & Field2

And mark "Show as a tree view"