Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
robpag46
Creator
Creator

Sum from another field

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

24 Replies
sunny_talwar

What are you expecting to see?

robpag46
Creator
Creator
Author

lets say if i select item 1, i would like to see the qty of all oils

    

skutypeqtysub qty (oil)
1finished1039

thansk

sunny_talwar

May be this:

Sum(TOTAL {<[SKU NO], TYPE = {'Oil'}>}QTY) * Avg(1)

Capture.PNG

robpag46
Creator
Creator
Author

it should just show the figures from

   

3,Oil
4,Oil
5,Oil

I should be able to add the dim sub if required

result should be

 

ItemTypeSub qty (type oil)
1finished12
1finished13
1finished14

thanks

sunny_talwar

I am not sure I understand the logic behind this? Would you be able to explain what you are trying to do?

robpag46
Creator
Creator
Author

sure!

Lets say i have an SKU NO 1, which is build of components (SUB) 3 and 4. Now i would like to display by expresion the Sub stock quantities from the SKU NO. The link which Sub belongs to which item is done in the relation table.

like sum({<Item = {'sub from the relation table'} , Type = {'Oil'}>} QTY)

Result should be

  

DimDimExpression (qty from sub oil)
SKU NOSUB QTY
1312
1413
1514

the expression should also work if Dim SUB is removed

  

DimExpression (qty from sub oil)
SKU NOQTY
139

Thanks Sunny

varshavig12
Specialist
Specialist

Your exp should work.

robpag46
Creator
Creator
Author

Hi, can you eventually add the expression to the sample .qvw attached? Would be great, as i couldnt get it work ...

Thanks Varsha

varshavig12
Specialist
Specialist

I'm using personal edition.