Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is a simplified task I am facing now.
Lets say we have two tables in the datamodel.
Table1: Items
100
10
Table2: ItemComponents
Component Item No
Items are made of component items.
Now, I want to create a straight table like below in Qlikview:
Can I write an expression to get the component stock in this straight table without making changes to the data model?
Thanks.
May be
Aggr(Max(Stock) ,[Item No]) for Item Stock
and
Max({1<[Item No]={"$(=Max([Component Item No]))"}>}Stock)