topic Re: Performance Issue UI in QlikView

Performance Issue UI

sujeetsingh — Fri, 12 Sep 2014 03:32:36 GMT

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.

Re: Performance Issue UI

jagan — Fri, 12 Sep 2014 04:03:01 GMT

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.

Re: Performance Issue UI

sujeetsingh — Fri, 12 Sep 2014 04:45:42 GMT

Thanks, Jagan,

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

Re: Performance Issue UI

jagan — Fri, 12 Sep 2014 05:03:26 GMT

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.

Re: Performance Issue UI

vinay_hg — Fri, 12 Sep 2014 05:04:10 GMT

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.

Re: Performance Issue UI

SunilChauhan — Fri, 12 Sep 2014 05:41:09 GMT

try moving all expression into script.

try to merge tables if posible

Re: Performance Issue UI

sujeetsingh — Fri, 12 Sep 2014 05:46:58 GMT

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

Re: Performance Issue UI

sujeetsingh — Fri, 12 Sep 2014 05:48:24 GMT

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

Re: Performance Issue UI

sujeetsingh — Fri, 12 Sep 2014 05:49:09 GMT

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

Re: Performance Issue UI

sujeetsingh — Fri, 12 Sep 2014 05:49:45 GMT

Folks,

what about using the qvd?

Do they can help in this case ?

Re: Performance Issue UI

Fri, 12 Sep 2014 06:02:50 GMT

Hi sujeet,

to Optimize your qlikview application please follow the checklist given in the attached document

Regards,

Vivek

Re: Performance Issue UI

jagan — Fri, 12 Sep 2014 06:07:46 GMT

Hi Sujeet,

If you are displaying all the records in the Straight/Pivot/Table box then definitely the performance issue occurs. So better restrict the data in Tables.

Regards,

Jagan.

Re: Performance Issue UI

Fri, 12 Sep 2014 06:56:04 GMT

It depends upon till what level the data model is normalized. More the de-normalized data model, more faster processing.

Also, for a most of the common dashboard information, how much nodes of data model qlikview has to traverse.

Thanks,

Singh

Re: Performance Issue UI

sujeetsingh — Mon, 15 Sep 2014 11:03:56 GMT

Vivek i have already gone through these stuffs

Re: Performance Issue UI

sujeetsingh — Mon, 15 Sep 2014 11:05:44 GMT

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.