topic Re: Load distinct in QlikView

Load distinct

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

if do load distinct in script will it effect to qvw performance ?

load Distinct

product,

orders,

sales,

......

from .... qvd;

thanks

Sony

BalaBhaskar_Qlik — Wed, 01 Aug 2018 09:43:37 GMT

Yes, Definitely, it'll improve performance.

Join and concatenate, outputs most of the records from data source.

It'll remove Duplicate records from input as well as Output. Records count is less.

So, when using Distinct, should have a temp table.,

Refer this:

arvind_patil — Wed, 01 Aug 2018 09:48:39 GMT

Hi Sony,

If your table has duplicate records then only it helps. or else it takes time same as previous one.

Thanks,

Arvind Patil