topic Re: Need Clarification in QlikView

Need Clarification

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

HI All,

I have 20 QVD's.... I need whole data from 20 QVD's.

Using Concatenate i made one QVD, but it's talking more reloading time.

(Note: Few tables i have same fields)

Concatenate is make sense??

How to improve performance...???

Please give me suggestions...

Thanks in Advance....

Re: Need Clarification

its_anandrjs — Tue, 15 Mar 2016 19:10:37 GMT

Hi,

If you take 20 qvds data into single Qvd there are questions to be ask.

1. Will all qvd has same fields.

2. Try the incremental load onto the qvd loading and then concatenate to increase the performance.

3. Try to create to optimized qvd that will take less time to load means take only necessary data.

Regards

Anand

Re: Need Clarification

amayuresh — Wed, 16 Mar 2016 04:12:59 GMT

1. if there are few Dimension tables, then may be join will help.

2. choose only required field in result set

3. You can use Autonumber() function for Text Data type Keys, this may help you

Re: Need Clarification

Chanty4u — Wed, 16 Mar 2016 06:00:30 GMT

hi,

Qlikview Optimization Techniques??

Turning Unoptimized Loads into Optimized Loads

how to improve the perfomance ?

Re: QV App performance

Re: Need Clarification

Kushal_Chawda — Wed, 16 Mar 2016 06:11:11 GMT

If all your 20 QVDs having the same structure i.e same number of fields with same name then you can probably use '*' to load all QVDs like below

load *

From Path\*.qvd;

But if all the QVDs don't have same structure then You should go for concatenate, but question here is

What is the reason for creating Separate 20 QVDs?

Re: Need Clarification

ramasaisaksoft — Wed, 16 Mar 2016 07:31:25 GMT

Hi QV Tester,

My Suggestion is first choose Big Qvd's which are having huge amount of data fetch these all are into one QVW file and now

Create ur new qvw file with binary load for huge amount of data files and fetch remaining qvd's also depends on logic

Note:- Comparatively QVD's load ,Binary Load is a bit fast.

Re: Need Clarification

Nagaraju_KCS — Wed, 23 Mar 2016 06:31:26 GMT

HI Kush,

I have 20 views fetching form SQL.

I need whole data. because of that i have concatenate all QVD's.

7 tables are almost same structure, remaining QVD's only 2, 3 fields same.

Thanks...