Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey friends
i have a problem showing the the inventory qtyf rom another field which is linked (BOM).
Basically i have 3 tables
1. Inventory figures by Item
2. item relations (Multilevel BOM)
3. Item data ( item informations such type and so on....)
Now i would like to show the stock of an subassambly by expression. Tried planty of things, but somehow i just dont get it done. how should the expression look like?
i have attached a sample .qvw which is reflecting my RL data
Would be great if somebody could help
Many thanks and rgs
Rob
Do you want something like this:
You can Hide the type.
Is this ok ?
Note: I guess my "SUB" is your "SKU NO"
here we go, sample data for upload
InventoryQTY:
LOAD * Inline [
SKU NO , QTY
1 , 10
2 , 12
3 , 14
4 , 16
5 , 18
6 , 20
7 , 22
8 , 24];
BOM:
load * Inline [
SKU NO , SubAssembly
1 , 3
1 , 4
1 , 5
1 , 6
1 , 7
1 , 8
2 , 3];
ItemInfo:
LOAD * Inline [
SKU NO , Type
1 , Finish
2 , Finish
3 , Oil
4 , Oil
5 , Oil
6 , Fuel
7 , Fuel
8 , Fuel];
if all works the result should be
| Dim | Dim | Expression(qty from Sub) |
| SKU NO | SubAssembly | QTY |
| 1 | 3 | 14 |
| 1 | 4 | 16 |
| 1 | 5 | 18 |
| 1 | 6 | 20 |
| 1 | 7 | 22 |
| 1 | 8 | 24 |
| 2 | 3 | 14 |
or without SubAssembly Dim
| Dim | Expression(qty from Sub) |
| SKU NO | QTY |
| 1 | 114 |
| 2 | 14 |
or if the item type oil is specified, with and without SubAssembly as dimension
| Dim | Expression(qty from Sub, type = oil) |
| SKU NO | QTY |
| 1 | 48 |
| 2 | 14 |
| Dim | Dim | Expression(qty from Sub, type = oil) |
| SKU NO | SubAssembly | QTY |
| 1 | 3 | 14 |
| 1 | 4 | 16 |
| 1 | 5 | 18 |
| 2 | 3 | 14 |
many thansk for your support 
I guess you are considering SKU NO as SubAssembly.
Considering the first record from your output,
if SKU NO is 3 , SubAssembly is 3 then the value should be 14.
But, if SKU NO is 1, SubAssembly is 3 then the value should be 10.
Can you have a look to my sample to upload above? Bassically the step to link the qty is missing in your sample. What im trying is to get the also the QTY from the SKU NO in your sample
Thanks
Jep i need both informations
SKU NO, QTY, SubAssembly, QTY
1, 10, 3, 14 this fieldvalue i need
Just to display the figures from the InventoryQTY Table (SKU NO) and adding a dimension (SubAssembly) and displaying the item type 'Oil' is not my problem.
this could be easely solved by
sum({<Type = {'Oil'}>} QTY) expression
but im looking for an expression which will tell me the qty of the SubAssembly. So bassically i need to use the SubAssembly fieldvalue from the BOM: table and check in the InventoryQTY table, what the stock is.
ok i will check, hope it will work
many thanks for your support!! 
In your app you have renamed the field [SKU NO] into [SubAssembly] and the [SubAssembly] the other way around.
Doing this i will loose still one qty information. [SKU NO] quantity is mandatory, additionally i need the quantity from the subassembly.
Sample
SKU NO, QTY, SubAssembly, QTY
1, 10, 3, 14 this fieldvalue i need
Just to display the figures from the InventoryQTY Table (SKU NO) and adding a dimension (SubAssembly) and displaying the item type 'Oil' is not my problem.
this could be easely solved by
sum({<Type = {'Oil'}>} QTY) as expression
but im looking for an expression which will tell me the qty of the SubAssembly. So bassically i need to use the SubAssembly fieldvalue from the BOM: table and check in the InventoryQTY table, what the stock QTY is.
something like
sum({<Item = {'sub from the relation table'} , Type = {'Oil'}>} QTY)
Thänks