Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sujeetsingh
Master III
Master III

Performance Issue UI

Hello Everyone,

I just have qvw file with 60k records. I deployed it with hardware configuration as 16 GB RAM and multiple CPU.

Now the UI click and selection are too slow. The UI contains

--7 to 10 tabs

--some are hidden

--on field triggers too

--Print reports for each tab

--Pivot tables on each tab

--all objects have multiple (dimension near about)

--Expression is count distinct

Now i want to see that can we enhance the UI clicking and navigation.

1 Solution

Accepted Solutions
sujeetsingh
Master III
Master III
Author

Thanks ,

All friends for your help and zeal to help. I was just expecting some tremendous trick or experience from any one who have optimized a pre existing report.

View solution in original post

14 Replies
jagan
MVP
MVP

Hi Sujeet,

Check this Sheet Properties-> Objects -> and check Calc Time of the objects which are taking more time and try to optimize those charts, if it is Pivot tables then show less data by making selections by using

Chart Properties-> General-> Calculation Condition

Hope this helps you.

Regards,

Jagan.

sujeetsingh
Master III
Master III
Author

Thanks, Jagan,

I have already tried this but not the Calculation Condition can you please explain how can one use it .

jagan
MVP
MVP

Hi Sujeet,

Suppose if you have pivot table showing all the data then the performance issues may arise, so restrict the display of records by asking user to select some filters to limit the data in tables.

Calculation Condition = Count(ID) < 10000 (Now if the possible records is less than 10000 then the pivot table is displayed with data otherwise it shows error message)

Hope this helps you.

Regards,

Jagan.

vinay_hg
Creator III
Creator III

hi sujeet,

can you brief abt data, how many tables?, what kind of data schema you have created with that? how you are loading these data into dashbaords.?

in qvw

use less if condition, use set analysis

how many users are accessing? check in the peak time what is ram usage by your dashboard.

if you provide all these details then it will be helpful to resolve the same.

Sunil_Chauhan
Champion
Champion

try moving all expression into script.

try to merge tables if posible

sujeetsingh
Master III
Master III
Author

Jagan,

Is the objects are too weak in memory point of view that they can not represent lacks of records.?

I need to show all records

sujeetsingh
Master III
Master III
Author

The data model is best and looks neat and clean with all precaution of scripting.

sujeetsingh
Master III
Master III
Author

Seems that can be a option but it will only make things complex

sujeetsingh
Master III
Master III
Author

Folks,

what about using the qvd?

Do they can help in this case ?