Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Pulkit_Thukral
Partner - Creator II
Partner - Creator II

AGGR function alternate option ,if any?

Faced an issue in qv functionality .

Dealing with different objects particularly  Straight Table ,Gauge Chart , Text Box.

In Straight Table under Expression Tab we have an option - Total in first row or Average in first row .

But to to provide the same row wise calculation figure in a gauge chart or a text box ,We have to use AGGR Function which slows the performance a bit and adding to that the entire Expression  has to get changed,

So,Is there any othr alternative available for AGGR Function ?

Thank you

1 Reply
marcus_sommer

Are the expressions within aggr() already optimized - not deep nested if-loops, condition-checks with numeric flags - there is nothing to replace the aggr() itself, unless you makes these Tables/calculations within the script which will have a great impact on the gui-performance.

- Marcus