Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bruno_m_santos
Partner - Creator
Partner - Creator

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

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

4 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
bruno_m_santos
Partner - Creator
Partner - Creator
Author

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

pivot.jpg

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
bruno_m_santos
Partner - Creator
Partner - Creator
Author

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