Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Flat table

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!

5 Replies
Not applicable

Re: Flat table

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)

Not applicable

Re: Flat table

Hi

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

Regards

Varshan

Employee
Employee

Re: Flat table

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

Not applicable

Re: Flat table

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

V

List.PNG.png

Employee
Employee

Re: Flat table

Create a field into your table using

Field1 & '/' & Field2

And mark "Show as a tree view"

Community Browser