Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What are the causes of poor chart performance?

Hi

can any body tell me what are tha major causes for poor performance of chart

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Hi,

Performance issues in charts is because of

- Huge Calculations in front end instead of doing in script

- Use of Distinct, IF() and Aggr()

- Showing huge data for example all Transactions data, also issues especially araises in Table boxes and Straight and Pivot tables.

- Inadequate RAM and  system resources

- Huge file size

etc.

Regards,

Jagan.

View solution in original post

3 Replies
Specialist
Specialist

(1)  Using expressions with Distinct key words

(2)  Too many dimensions and expressions

(3)  Having dimensions with lowest granularity Ex: Account ID,transaction

(4) using two much set analysis (nested if')  and Conditional hide/show

MVP & Luminary
MVP & Luminary

Hi,

Performance issues in charts is because of

- Huge Calculations in front end instead of doing in script

- Use of Distinct, IF() and Aggr()

- Showing huge data for example all Transactions data, also issues especially araises in Table boxes and Straight and Pivot tables.

- Inadequate RAM and  system resources

- Huge file size

etc.

Regards,

Jagan.

View solution in original post

Not applicable

Add Minicharts to that. If the minichart has a complex expression and spans a number of years/months, then that causes a significant performance hit.