Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How we can decrease the chart response time in qlikview
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
Hi Shweta,
Can you share your expression here . So that some body can help you to change the expression in good way.
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
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..
How performance can be increased using if else conditions.
3. Try to avoid Set Analysis, if it can be achieved using if else conditions... ?
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
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)
can we do any thing with the datamodel
Is it necessary?Please see the attachment with the query in my first comments