Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

How to copy an expression value to a different table

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

1 Reply
MVP
MVP

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...