topic Re: Optimization Tips Required in QlikView

Optimization Tips Required

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

Hi Communtiy,

I want to optimize my Data for QVW.

Currently when i selected multiple years and month selections its stuck and go into not responsding mode.

i had son concatenated field there which i used as a KEY in table and at expression levels it perform aggr function.

Please suggest some technique to optimize the data.

Awaiting your reply.

Regards

Re: Optimization Tips Required

stabben23 — Thu, 06 Oct 2016 05:28:39 GMT

Hi,

To use aggr as expression could be very memory expensive. All Depends on Your datamodel and how these Dimensions in Connected to the fact transactions. Could you perhaps show us the Application.

Are you shure that Year and month is Connected to Your fact table?

Re: Optimization Tips Required

nagarjuna_kotha — Thu, 06 Oct 2016 05:38:44 GMT

Check Follow below Reasons:

1.Apply conditional show to that chart Example: After selecting Year and month the chart should display.

2.u can also Create Ad-hoc report for such cases.

3.If you have calculated dimensions in your chart , try to create those in backend and use them.

4.if you are using Set Analysis in ur expressions , use Set Analysis.

I Hope this might helps you.

-Nagarjun

Re: Optimization Tips Required

nagarjuna_kotha — Thu, 06 Oct 2016 05:43:44 GMT

there shouldn't be calculated dimensions, aggr-functions or nested if-loops) but the best way would be to reduce the number of dimensions and expressions. 20 + 10 = 30 columns is far more as it would be sensible.

I Hope this might helps.

-Nagarjun

Re: Optimization Tips Required

noman212 — Thu, 06 Oct 2016 06:13:01 GMT

Please find the attached data model with facts and dimensions tables.

CAn you please explain how can i assign concatenated fields with fixed numbers

like if i have a QVD from which i used two fields as a key

For Example :

Table A :

ID,

from Table A,qvd(qvd);

from above table i concatenate 2 fields as a key.

Table A :

ID & A as KEY,

from Table A,qvd(qvd);

I want to assign a permenant number against each product for dimensions tables can u please help me to assign fixed number to each product currently in qvd we have almost 32B data against 4 to 5 qvds.

Re: Optimization Tips Required

noman212 — Thu, 06 Oct 2016 06:13:54 GMT

nagarjuna.kothamandi

Re: Optimization Tips Required

stabben23 — Thu, 06 Oct 2016 06:36:59 GMT

Hi,

i'm not sure what you want to achieve, but if you want to use concatenated keys, the keys must be concatenated With the same Field also in the Dimension table. I can also see that you have some "leavs" (xxxshop and one more), maybe use applymap so the Fields will be in one table.

Concatenated keys should be on the lowest granularity.