Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
davymichiels
Contributor
Contributor

choose what dimension to use for set expression if multiple dimensions

Hello,

I'm kinda stuck on this one that I would like to solve without altering the script :

I have a data table with components that are parts of articles.

Both components and articles have stock values.

One table says article 1 = made up of component A, component B, component C, ...

(like 1 = 5*A + 3*B + 1*C, 2 = 1*A + 3*D, ...)

Other table says stock values etc. for each component and article

(like 1= 50, 2=20, A= 10, B=5, ..)

In script is defined that in the first table dimension = ART and expression is COMP

in second table dimension = ART (both articles and components)

I can reverse and tell what components are used in what articles:

dimension 1 COMP, dimension 2 ART.

Now I would like to show stock value as expression but although they are written in the same

notation, I cannot get stock value next to dimension 1 because stock value is linked to ART.

I am searching for something like

sum({$<ART= {$(COMP)} stockvalue) but than line by line

(like "give me stock value for ART = COMP mentioned in this line's dimension 1")

All help is appreciated

Davy

0 Replies