topic Using the result value from one table in another table in QlikView

Using the result value from one table in another table

Mon, 05 Jul 2010 10:42:26 GMT

Hi all, thank you for your help.

Here is another question.

I have an expression named 'Formulae' with some complex calculations in straight table.

is there any way to use its value (actually, I need sum(Formulae)) in another table or I should recalculate it?

Thank you.

Using the result value from one table in another table

Miguel_Angel_Baeyens — Mon, 05 Jul 2010 11:22:47 GMT

Hello,

In that case you may set your expressions as variables in your load script, so you can reference them later on. For example:

SET vFormulae = Sum(Amount);

And then use

$(vFormulae)

as expression in your charts.

Using the result value from one table in another table

Mon, 05 Jul 2010 12:18:31 GMT

Thank you but this is not my case

Again,

I have a straight table, some expressions are coming from SQL, some are calculated.

All formulas below are simplified.

ColumnA=Date (from SQL)

ColumnB=InOutFunds (From SQL)

ColumnC=below(Date)-Date (calculated expression)

ColumnD=ColumnB+above(ColumnD) (calculated expression)

ColumnE=ColumnD*ColumnC/365 (calculated expression)

Date	InOutFunds	Term	Investments	ColumnE
01.01.2005	100	31	100	8.49
01.02.2005	120	15	220	9.04
16.02.2005	75	10	295	29.5

The sum of ColumnE counts in Total of the table and this value I want to use in another table.

Using the result value from one table in another table

Miguel_Angel_Baeyens — Mon, 05 Jul 2010 12:34:57 GMT

Hi,

So if I understand you correctly, there is no other way to pass one expression into another chart. You will need then to recalculate in your new chart.

Well, maybe using macros you will get it...