Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I was talking about data model improvements
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
Oh I thought you talk abt setting . Sorry
Sent from Samsung Mobile
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],
))))))))))))
Hi Clever
can you pls share with me why list box expression will affect the loading time ?
Paul
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 ?
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
Hi Clever
Thank you for help me.
i am not able to open the QV doc. you using ver 9 ?
Paul
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
Hi Clever
I do try your script , and it does work and it does help to reduce the number of table . appreciated.
Paul