topic Re: Optimization in QlikView

Optimization

tulsidaskhan — Thu, 02 Jun 2016 14:08:11 GMT

Hi,

In accordance with optimization, is there any difference between 'GETFIELDSELECTIONS' and

'GetFieldSelections' .

Thanks,

Piyush

Re: Optimization

Chanty4u — Fri, 03 Jun 2016 11:22:10 GMT

Hi,

No change

As Qlikview is Case sensitive but not Qlikview Functions

Re: Optimization

marcus_sommer — Fri, 03 Jun 2016 14:29:48 GMT

A small addition to the answer from sureshqv. Regarding to the way how qlik cached calculations there will be a difference if you used in one expression: sum(Value) and in another SUM(Value) or maybe = sum(Value).

From caching point of view need an expression to be exactly the same (1:1 in everything - each space will be a difference) to be chached as the same expression otherwise qlik will be (like in the sum-example from above) cache three expressions and this will increase the RAM consumption and the computing times (in small applications rather not noticeable but in the larger ones).

- Marcus

Re: Optimization

trdandamudi — Fri, 03 Jun 2016 14:54:04 GMT

Caching point of view, you have to have an expression to be exactly the same. If you have the same expression in different variations (like upper or lower case, equal sign etc.,) then the RAM consumption will increase and this is noticeable on large applications. Hope this helps....