Straight Table Problem - Non Associate Table

Fri, 19 Sep 2014 16:36:14 GMT

I have 2 tables which are not associated to one another but have the same dimension valuesI would like to display the sum of values for second table with respect to first table dimensions

LOAD * INLINE [ A, B, C A1, B1,11 A2, B2,21 A3, B3,31 ]; LOAD * INLINE [ X, Y, Z A1, B1,10 A2, B2,20 A3, B3,30 ]; The result must be, even when selections(B=B1) are made: A =Sum(Z) - A1 10 A2 20 A3 30 But they are, when I select B=B1 : A =Sum(Z) - A1 10 A2 A3

Re: Straight Table Problem - Non Associate Table

sunny_talwar — Fri, 19 Sep 2014 16:47:37 GMT

I am not sure if this is what you are looking for, but take a look at the qvw file.

Best,

topic Re: Straight Table Problem - Non Associate Table in QlikView

Straight Table Problem - Non Associate Table

Re: Straight Table Problem - Non Associate Table