Expression Help

mayuranp — Wed, 09 May 2018 21:46:29 GMT

Here is a simplified task I am facing now.

Lets say we have two tables in the datamodel.

Table1: Items

Table2: ItemComponents

Items are made of component items.

Now, I want to create a straight table like below in Qlikview:

Item No	Component Item No	Item Stock	Component Stock
A001	C001	100	40
A002	C002	50	20
A002	C003	50	10

Can I write an expression to get the component stock in this straight table without making changes to the data model?

Thanks.

Re: Expression Help

sasiparupudi1 — Fri, 11 May 2018 12:56:41 GMT

May be

Aggr(Max(Stock) ,[Item No]) for Item Stock

and

Max({1<[Item No]={"$(=Max([Component Item No]))"}>}Stock)