topic Re: Use an expression in pivot table which was previously loaded in a table in QlikView

Use an expression in pivot table which was previously loaded in a table

bruno_m_santos — Wed, 10 Oct 2012 19:11:11 GMT

Is it possible to use an expression in a pivot table, which was previously loaded in a table?

My pivot table is linked to formulas table, by Schema and line fields.

Sample formula to Line L005:

sum ( aggr( sum(TOTAL{$<MonthID = {$(=Max(MonthID))},
Date = {"<=$(=Max(Date))"},
Year = ,
Quarter = ,
Period = ,
[Period (#)] = ,
Schema={TEST},
Line={L005},
Month = >}Amount),Line))

So in my pivot for a specific Schema and Line, I want to run the corresponding expression.

Thanks in advance.

Bruno

Re: Use an expression in pivot table which was previously loaded in a table

Gysbert_Wassenaar — Wed, 10 Oct 2012 19:14:34 GMT

The values for schema and line should be in quotes:

sum ( aggr( sum(TOTAL{$<MonthID = {$(=Max(MonthID))},
Date = {"<=$(=Max(Date))"},
Year = ,
Quarter = ,
Period = ,
[Period (#)] = ,
Schema={'TEST'},
Line={'L005'},
Month = >}Amount),Line))

Re: Use an expression in pivot table which was previously loaded in a table

bruno_m_santos — Wed, 10 Oct 2012 20:31:28 GMT

Sorry,

but my problem is that the expression, in my pivot is treated like a text not an expression.

See the image please.

How can I run an expression stored in a table.

Thanks

Bruno

Re: Use an expression in pivot table which was previously loaded in a table

Gysbert_Wassenaar — Thu, 11 Oct 2012 07:41:36 GMT

And if you put an = sign in front of the expression?

Re: Use an expression in pivot table which was previously loaded in a table

bruno_m_santos — Thu, 11 Oct 2012 09:17:46 GMT

Same result

My expression in Pivot is "=Expression"

Returns the expression text (now with "="), but doesn't execute the expression. If I copy cell text, and create another column with the copied expression returns values.

Any idea

Bruno