topic Re: Reusing Aggr function in QlikView

Reusing Aggr function

prabhu0505 — Tue, 05 Nov 2013 17:11:32 GMT

Is there any way I can reuse the aggr function especially it's virtual table?

Say for instance, below expression which i thought of re-using is part of almost all of my final expressions.

aggr(sum(A/B), Dim1)

Final Expressions:

aggr(sum(A/B), Dim1) - Sum(D)

aggr(sum(A/B), Dim1)/Sum(E)

aggr(sum(A/B), Dim1)*100

and many..

So by any chance I could reuse the virtual table created by one Aggr function to all of my final expressions?

Re: Reusing Aggr function

tresB — Tue, 05 Nov 2013 17:37:53 GMT

Say your first expression: =aggr(sum(A/B), Dim1) and label it as 'AAA'

then you can refer this expression in following expressions like:

=AAA-Sum(D)

=AAA/Sum(E)

Or,

=Column(1)/Sum(D) // column(N), 'N' is the expression column position which you refer

Or, even you can define a variable for the expression and refer it wherever you need it.

Re: Reusing Aggr function

Clever_Anjos — Tue, 05 Nov 2013 17:55:03 GMT

Create a variable using your constant expression and use it

aggr(sum(A/B), Dim1)

Please refer to http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables

Re: Reusing Aggr function

prabhu0505 — Tue, 05 Nov 2013 18:15:01 GMT

Thanks for the response..

I've read a post by Barry regarding labeling and using variable instead of

direct expression but he concluded saying neither of them posses attractive

performance benefit.

Currently Im in a situation where one of chart is taking almost 10 mins to

load, I've get of rid of it.

Re: Reusing Aggr function

tresB — Tue, 05 Nov 2013 18:27:07 GMT

The more you use AGGR and such complex expressions in the UI, your UI performance would suffer. You can't hold the calculated values(apart from single value in a variable) in UI. Therefore, to get rid of it, you might have to contemplate on bringing some calculations in the script.