Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist 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

1 Solution

Accepted Solutions
Highlighted

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/

View solution in original post

2 Replies
Highlighted

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/

View solution in original post

Highlighted
Partner
Partner

Hi Sony,

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

Thanks,

Arvind Patil