topic QV developement Optimization in QlikView

QV developement Optimization

Anonymous — Tue, 11 Dec 2012 15:39:42 GMT

Hi,

I need your help to optimize my report on QV.

I developed a report respecting the star modeling, but the key who linked my fact table with my other table content a concatenation of 9 fields, knowing that i've more that 6 million of rows.

I thinks that this way of creating my key break down the performence of my report.

can you advice me how to develop properly my report ?

thanks.

Re: QV developement Optimization

RedSky001 — Tue, 11 Dec 2012 15:47:33 GMT

You want to try and keep your joining field values as short as possible, for example

'Value1' & 'Value2' & 'Value3' as myKey

The length of the field is quite high 18.

Use Autonumber()

Autonumber('Value1' & 'Value2' & 'Value3') as myKey

This is taken from the help:

Returns a unique integer value for each distinct evaluated value of expression encountered during the script

execution. This function can be used e.g. for creating a compact memory representation of a complex key.

In order to create multiple counter instances if the autonumber function is used on different keys within the

script, an optional parameter AutoID can be used for naming each counter.

(If you'd like further assistance you might want to upload your QVW or at least a screen grab of the data model.

Re: QV developement Optimization

Anonymous — Tue, 11 Dec 2012 16:02:14 GMT

i used autohashnumber256.

i can't upload the QVW , 70Mo , iit will be hard

so i'll upload some screen :

Re: QV developement Optimization

RedSky001 — Tue, 11 Dec 2012 16:16:23 GMT

Rereading your first post I'm now unclear what you are asking for, your question is vague.

Perharps a metaphor would be if you took your car to a garage and asked the engineer "Can you make my car work better?"

"I thinks that this way of creating my key break down the performence of my report.

can you advice me how to develop properly my report ?"

Are you suggesting you have not devloped your report* properly?

What do you mean by "report" do you mean the data model or the UI?

Are you experiencing performance issues, what are they, what are you expecations?

Re: QV developement Optimization

Tue, 18 Dec 2012 14:41:58 GMT

Hello.........

Please can any one help me to under stand the difference b/w

QMC and QEMC?