topic Re: how to decrease chart response time in QlikView

how to decrease chart response time

Thu, 21 May 2015 08:54:42 GMT

How we can decrease the chart response time in qlikview

Re: how to decrease chart response time

Siva_Sankar — Thu, 21 May 2015 09:06:16 GMT

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

Re: how to decrease chart response time

Anonymous — Thu, 21 May 2015 09:28:54 GMT

Hi Shweta,

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

Re: how to decrease chart response time

avinashelite — Thu, 21 May 2015 09:36:46 GMT

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

Re: how to decrease chart response time

manojkulkarni — Thu, 21 May 2015 09:47:42 GMT

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..

Re: how to decrease chart response time

Anonymous — Thu, 21 May 2015 09:55:07 GMT

How performance can be increased using if else conditions.

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

Re: how to decrease chart response time

Thu, 21 May 2015 10:00:26 GMT

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

Re: how to decrease chart response time

avinashelite — Thu, 21 May 2015 10:23:18 GMT

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)

Re: how to decrease chart response time

Fri, 22 May 2015 05:17:06 GMT

can we do any thing with the datamodel

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