Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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...