topic Getting value from a different Object in QlikView

Getting value from a different Object

Anonymous — Mon, 14 Mar 2016 21:40:06 GMT

All,

I'm trying to see if you can get value from a different Table.

For example: For table 2 - I want field Company and Date, as well "Total" column from table 1 (not Sum(vaule1,vaule2, vaule3)

Is there expression where you can reference table1 fields/columns?

Table 1:

Table 2:

Company

Date

Total

ABC

3/1/2016

XYZ

3/1/2016

Thanks,

Frank

maxgro — Mon, 14 Mar 2016 21:58:49 GMT

try with

RangeSum(Value1, Value2, Value3)

int the 2nd table

Anonymous — Mon, 14 Mar 2016 23:02:01 GMT

Thanks.. It works.

Anonymous — Tue, 15 Mar 2016 03:31:21 GMT

how do rangsum a column or Label name? Thanks