topic Re: How to Reduce Calculation time for a given object in QlikView

How to Reduce Calculation time for a given object

Anonymous — Tue, 17 Sep 2013 18:56:41 GMT

Hi qlikgurus,

for one my gauge chart the calucation time is 41480 and for text box the calculation time is 13260.... (as there are many object in this sheet of all those these two objects are loading very slowly )

when i moved them in to a different sheet the calculation time decreased to

gauge chart - 12342

text box - 12324

the main problem is in expression area ( i'm using variables to calculate these expression and these are very complex as i have a single KPI which is a roll up of 5 metrics (each with of different relativeness) and has to sastify many conditions (there are many 'IF' condition too)

so in short,.....there is no way that i can change these expression (that's how the logic is required )

And as of now i'm working on my local machine does the calculation time changes when deployed into server ?

will the increase in CPU's have any impact (decrease in Calculation Time)

the calculation which is shown is it in microseconds ?

any suggestion will be lot help ful

Thanks

Sri

Re: How to Reduce Calculation time for a given object

Anonymous — Tue, 17 Sep 2013 19:07:36 GMT

Hello Sri,

My first reaction would be to put calculation inside the script.

I have also noticed that as a tweak, to have your charts minimised to begin with. This reduces calculation time for observed charts.

Kind regards,

Antoine

Re: How to Reduce Calculation time for a given object

Anonymous — Tue, 17 Sep 2013 19:19:19 GMT

Thanks for the reply Antoine,

i'm declaring all the variables in the script using "set" and using the variable names in chart expression .... the main problem is all these variables are inter-realted to other varibles that are being calculated at the same time .

and one more issue that seems to me every time we navigate from one sheet to another .....these are variables are getting calculated may there no cache thing going and is very furstating that it's taking minutes to naviagte form maim sheet to next sheet

Re: How to Reduce Calculation time for a given object

Anonymous — Tue, 17 Sep 2013 19:23:13 GMT

What I meant was to calculate the variable (not only declare it) inside the script.

Then you only present your figure in the chart (and not calculate it on the fly), reducing this way calculation time.

Re: How to Reduce Calculation time for a given object

Anonymous — Tue, 17 Sep 2013 19:37:18 GMT

I just used let to each variable but it's still the same (little better than earlier)

Re: How to Reduce Calculation time for a given object

Anonymous — Tue, 17 Sep 2013 19:41:57 GMT

maybe then include some of the common variables as fields inside some of your tables.

Might require some additional manipulation in the script though.

Re: How to Reduce Calculation time for a given object

Anonymous — Tue, 17 Sep 2013 20:29:50 GMT

that may not be possible not of them are in relative percantages which dynamics per selections.....

let hope some one can pour better workaround

Thanks again

Sri

Re: How to Reduce Calculation time for a given object

Anonymous — Wed, 18 Sep 2013 13:43:16 GMT

Any more suggestion plz

Re: How to Reduce Calculation time for a given object

prabhas277 — Wed, 07 Sep 2016 06:06:41 GMT

HI,

For example i have one expression in straight table like sum(sales). how i can write the same expression in script leavel? but the i want see the output in UI level only