topic table object getting refreshed for no reason in QlikView

table object getting refreshed for no reason

Mon, 07 May 2012 06:14:25 GMT

Hi,

In a particular tab I have 2 table objects, one of the table objects get refreshed just for any thing I do in that tab. For instance if I minimize the other object, or do some change in the expression or anything. Or if I add new object , delete new object... this particular table object get refreshed everything.

Also, it takes hell lot of time to display the data. This issue I am getting in development environment only...i.e in qlikview desktop, but on production it works fine.

Thanks,

Lax

table object getting refreshed for no reason

Sokkorn — Mon, 07 May 2012 07:19:47 GMT

Hi Lax,

Check NOW() function whether it used with your table object or not.

Regards,

Sokkorn

table object getting refreshed for no reason

Tue, 08 May 2012 06:48:16 GMT

Hi,

Not using any NOW() function. It refreshes whenever I touch other objects in that tab

Thanks

Lax

table object getting refreshed for no reason

Sokkorn — Tue, 08 May 2012 07:14:58 GMT

Hi Lax,

Can you share your app?

Regards,

Sokkorn

table object getting refreshed for no reason

deepakk — Tue, 08 May 2012 08:06:54 GMT

Hi Lax,

Its always better to use a pivot or straight table instead of a table box. The performance is always much better than table box.

Deepak

table object getting refreshed for no reason

Thu, 10 May 2012 13:57:25 GMT

Hi ,

I can share the data model..the main table is having around 2.7 million records and others are mostly master with hardly any data into them,

My dev. environment has become very slow, inspite of having 32 GB memory and 24 CPU. The size of the application/document is 456 MB.

Please do suggest, how can I improve the performance.

Thanks

Lax

table object getting refreshed for no reason

Thu, 10 May 2012 14:03:16 GMT

Here is it, Also this main table is having 75 fields.

table object getting refreshed for no reason

deepakk — Fri, 11 May 2012 10:33:40 GMT

hi Lax,

From the main table remove the fields which are not required in the application. As per my understanding in a an application you don't require all the field.

Also there is a linking issue. You can't link BankMaster Table with Qlikview_Data table with so many fields.

Check for the relation between this two tables. It might be only with one or two fields.

If you carry out this two activites your QV application performance will improve.

Deepak