Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to decrease chart response time

How we can decrease the chart response time in qlikview

8 Replies
Siva_Sankar
Master II
Master II

Shweta Singh, I understand that you are trying to increase the performance of chart calculation time. Chart calculation time may be slow because of complex expressions or due to large data set. Try to bring back the expressions in script level as much as possibe. Try limitting if there are more number of charts in a sheet. Refer Chart Optimization here https://community.qlik.com/docs/DOC-8437

Anonymous
Not applicable
Author

Hi Shweta,

Can you share your expression here . So that some body can help you to change the expression in good way.

avinashelite

Hi Shweta,

If your using any calculation in the dimension , please push it to script this will improve the response time and in the expression if your using if condition, try to avoid it and calculate in set analysis. This will help you in improving the response time 

manojkulkarni
Partner - Specialist II
Partner - Specialist II

1. Avoid using calculated dimensions & heavy aggregation at chart level.

2. while comparing any value, use numbers instead strings.

3. Try to avoid Set Analysis, if it can be achieved using if else conditions...

4. Most important thing is , proper data modelling..

Anonymous
Not applicable
Author

How performance can be increased using if else conditions.

3. Try to avoid Set Analysis, if it can be achieved using if else conditions... ?

Not applicable
Author

Dimension--'

if(Entity='aIMPL','Adidas',
if(Entity ='RIC','Reebok'))


Expression

Sum (if(Num_Month = num(month(FromDate)) and Posting_Year = Year(FromDate),net_qty))+
Sum(if([Posting Date] >=MonthStart(FromDate) and [Posting Date] < FromDate,Opn_Pur_TXN))+
Sum(if([Posting Date] >=MonthStart(FromDate) and [Posting Date] < FromDate,Opn_Sales_TXN))

  PFA for datamodel

avinashelite

Hi Shweta,

As mentioned, Please push the dimension calculation and the following calculation to script :

if(Entity='aIMPL','Adidas',if(Entity ='RIC','Reebok')) as new_column //use this in the dimension


calculate the month start and month in the expression:

MonthStart(FromDate)  as monthstart,

month(fromdate) as month,

num(month(FromDate)) as num_month


calculate this in the script .....and try with the same expression you will see a better response time.


if you want to increase further , when use set analysis like as below in the script.


create variable for the fromdate and end and use the same as below

sum({<Num_Month ={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"}>}Opn_Pur_TXN)

Not applicable
Author

can we do any thing with the datamodel

Is it necessary?Please see the attachment with the query in my first comments