Use calculated expression from another object -- possible?

Thu, 21 Feb 2013 16:13:46 GMT

Hi,

My goal is to plot a scatter chart based on 2 columns (expressions) in a straight table. However, one of the columns needs to be calculated from 2 other columns that are dynamic based on selections. I thought I can plot a scatter chart by hiding the non-relevant columns, but it did not work.

Questions:

1. Is there a way to do this within this object?

2. And/Or can I create another object with a column that is dynamically linked to the calculated column of the first object? (Would also appreciate answer to this question even if answer to #1 is yes.)

To illustrate: Say I have 4 columns (expressions) A, B, C, and D in a straight table object. Column C is calculated from the first 2 expressions (columns) -- e.g. Column C = column(1) + column(2). Goal is to create a scatter plot using C and D.

Thanking in advance,

Anthony

topic Use calculated expression from another object -- possible? in QlikView

Use calculated expression from another object -- possible?