Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

soniasweety
Valued Contributor III

Load distinct

Hi all,

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

load Distinct

product,

orders,

sales,

......

from   .... qvd;

thanks

Sony

Tags (2)
1 Solution

Accepted Solutions
Highlighted
balabhaskarqlik
Honored Contributor

Re: Load distinct

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:

http://www.qlikfix.com/2013/07/30/distinct-can-be-deceiving/

2 Replies
Highlighted
balabhaskarqlik
Honored Contributor

Re: Load distinct

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:

http://www.qlikfix.com/2013/07/30/distinct-can-be-deceiving/

arvind_patil
Valued Contributor III

Re: Load distinct

Hi Sony,

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

Thanks,

Arvind Patil