Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QV take 4 min to open , it is cause by too many TAB or Screen ?

Hi All

I have a QV doc , which take about 4 min to open this doc.

This doc is reading many QVD table. and it have many QV screen.

From my experience. i aware that if i have too many TAB ( Screen ) QV will need to load all the data on the chart or table before it open the QV doc to allow user to use the program.

So if i remove the number of  TAB from 100 to 50 , it will speed up the loading.

So i think this is the disadvantage of QV ver 9 , it cannot take in too many screen ?

can some one help me to confirm on this.

Paul

34 Replies
Clever_Anjos
Employee
Employee

I was talking about data model improvements

Bill_Britt
Former Employee
Former Employee

Hi Paul,

I think the key issue here is Version 9. They has been many advancements made in the last couple of years. I would test in on 11.20 SR3 and see how it reacts.

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable
Author

Oh I thought you talk abt setting . Sorry

Sent from Samsung Mobile

Clever_Anjos
Employee
Employee

Another point, this expression is beeing used into a ListBox, You could create another field into your model only containg G1..G12 and nulling other values and using this field

Same apply to all listbox using heavy calculations (I´m assuming your sales_table is big)

=IF(GROUP_CLASS='G1',GROUP_CLASS,

IF([GROUP_CLASS]= 'G2',[GROUP_CLASS],

IF([GROUP_CLASS]= 'G3',[GROUP_CLASS],

IF([GROUP_CLASS]= 'G4',[GROUP_CLASS],

IF([GROUP_CLASS]= 'G7',[GROUP_CLASS],

IF([GROUP_CLASS]= 'G6',[GROUP_CLASS],

IF([GROUP_CLASS]= 'G8',[GROUP_CLASS],

IF([GROUP_CLASS]= 'G9',[GROUP_CLASS],

IF([GROUP_CLASS]= 'G5',[GROUP_CLASS],

IF([GROUP_CLASS]= 'G10',[GROUP_CLASS],

IF([GROUP_CLASS]= 'G11',[GROUP_CLASS],

IF([GROUP_CLASS]= 'G12',[GROUP_CLASS],

))))))))))))

Not applicable
Author

Hi Clever

can you pls share with me why list box expression will affect the loading time ?

Paul

Not applicable
Author

Hi Bill

may be you are right , but i try to purchase ver 11 now QV only selling min 5 user license , and they refuse to sell 1 user license. it there any way i can test ?

Clever_Anjos
Employee
Employee

QlikView should traverse all your data, without looking at symbol table.

I´ve done some "clean-up" into your app. I could remove 5 of your synth keys. Its the best I can do without knowing more about your data and business rules

Please test the performance of this app

Not applicable
Author

Hi Clever

Thank you for help me.

i am not able to open the QV doc. you using ver 9 ?

Paul

Clever_Anjos
Employee
Employee

Version 11.

You can create your own.

Copy your app and use this script into new one

Binary ;

Currency:

NoConcatenate Load * Resident Currencies1;

drop Table Currencies1;

concatenate Load * Resident [Currencies1-3];

drop Table [Currencies1-3];

concatenate Load * Resident [Currencies1-2];

drop Table [Currencies1-2];

concatenate Load * Resident [Currencies1-4];

drop Table [Currencies1-4];

concatenate Load * Resident [Currencies1-5];

drop Table [Currencies1-5];

concatenate Load * Resident [Currencies1-1];

drop Table [Currencies1-1];

Exchange:

NoConcatenate Load * Resident INLA6D1;

drop Table INLA6D1;

Concatenate Load * Resident INLA6CE;

drop Table INLA6CE;

Concatenate Load * Resident INLA6D2;

drop Table INLA6D2;

Concatenate Load * Resident INLA6CF;

drop Table INLA6CF;

noConcatenate Load * Resident INLA6B6;

drop Table INLA6B6;

Concatenate Load * Resident INLA6B7;

drop Table INLA6B7;

noConcatenate Load * Resident INLA6BB;

drop Table INLA6BB;

Concatenate Load * Resident INLA6BC;

drop Table INLA6BC;

Left join(ExecProfitLoss_) load * Resident  IntervalMatch_;

drop Table IntervalMatch_;

Left join(ExecProfitLoss) load * Resident  IntervalMatch;

drop Table IntervalMatch;

drop Fields Year_n, Month_n; // these fields already exists into MasterCalendar

exit Script

Not applicable
Author

Hi Clever

I do try your script , and it does work and it does help to reduce the number of table . appreciated.

Paul