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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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