How to copy an expression value to a different table

Anonymous — Mon, 02 Nov 2015 22:47:57 GMT

Hello!

Hope someone could help me on this...

I have a rangesum formula from a different pivot table...

RangeSum(alt(Before(TOTAL [Gross Forecast]), 0), sum({$<Term = {'Supply'}>} Qty) - sum({$<Term= {'Demand'}>} Qty)) with field label [Gross Forecast]

Now I'd like to create a new pivot table and create an expression value to get the value from the other pivot table and multiply by 50%

I tried using [Gross Forecast] *.5 but doesn't work

I also tried using 2 expressions

where 1st ex label as Forecast

RangeSum(alt(Before(TOTAL [Gross Forecast]), 0), sum({$<Term = {'Supply'}>} Qty) - sum({$<Term= {'Demand'}>} Qty)) with field label [Forecast]

and 2nd expression as Forecast *.5 but still doesn't work.

Is there any way to do it?

Pls. advise.

Tks

Re: How to copy an expression value to a different table

swuehl — Mon, 02 Nov 2015 23:34:37 GMT

You can't access the expression values of one table from within another table.

You would need to replicate the expression values in the second table, if the dimensions of both tables differ, you can use advanced aggregation to create a 'virtual table':

AGGR...

topic Re: How to copy an expression value to a different table in QlikView

How to copy an expression value to a different table

Re: How to copy an expression value to a different table