Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Mattie
Contributor
Contributor

Creating network chart from database

Dear reader,

I want to create a Network chart, however I have some a different data structure than usual, here is an example (it is a splitting process, not combining):

IDMaterialoutputinput
1cookie 1
1chocolate1 
1dough1 
2pineapple 1
2peel1 
2middle1 
3cookie 1
3chocolate1 
3dough1 
3almonds1 
4cookie package 1
4cookie1 
4packaging1 

 

I want to see materials as nodes, and the connection between the materials. In example, from 'cookie package' you can go all the way to 'dough'. On the line I would like to see the ID number.

I hope you can help me out achieving this, if you need additional information I am happy to provide that!

Labels (3)
0 Replies