topic Calculation condition: loading 15 yrs of data, objects calculate on variable in QlikView

Calculation condition: loading 15 yrs of data, objects calculate on variable

sibrulotte — Fri, 05 Jul 2013 19:04:44 GMT

Hi,

so i was told it'd be quicker to load all the data from our warehouse, instead of selecting and posing the condition

Where

GLDetail.Annee_fiscale>=2009;

Thus only loading 5 years.

Load time is quicker without that condition, but object calculations are a pain.

So, how do I use the calculation condition in my objects (pivots) to limit the calculations done to only

GLDetail.Annee_fiscale = AnnCourBilan

Any help is appreciated.

Thanks

Simon

I've tried alot of combinations and still can't get to my goal

sibrulotte — Mon, 29 Jul 2013 17:56:39 GMT

Is there anyone one out there savy?

sibrulotte — Mon, 29 Jul 2013 17:57:25 GMT

Is there anyone one out there savy?

Is it possible to limit calculations of objects to years determined in a variable?