Solved: Re: Straight table Reloading again and again. - Qlik Community

sourabhverma107 · ‎2016-01-11

Hi,

We have SARA application which mainly deals with sales of several customers and products in which we have one hidden Straight Table ‘CV4’, now we have enable this table and refreshed the application.

Further now we could see that table is reloading again and again. We tried creating the new table with same dimension and expressions but it is also reloading again and again.

We are using Qlikview-9 version, can anyone help us on resolving this issue. Below is the snapshot from the application.

Thanks,

Sourabh

marcus_sommer · ‎2016-01-11

I have experienced such behaviour in releases prior to QV 11 and didn't found an always repeatable cause.

But you should check if there are any macros active (maybe firing by each selection or similar), variables are used in dimensions/expressions but also in captions or other areas (labels, conditions, groups, comments ...) and no functions like now() or today() are applied. Maybe there could be something replaced.

Other reason might be a corrupt application. This meant to recreate the object might not enough - but for checkings I would recreate such object step by step, one dimension and one expression and no further adjustments and look if the happens again and then extend the object slowly with further parts.

Further also the system might cause such behaviour if it run in a VM or if some RAM optimization tools like NUMA are working.

Btw: I would consider to upgrade to a newer Release.

- Marcus

View solution in original post

marcus_sommer · ‎2016-01-11

I have experienced such behaviour in releases prior to QV 11 and didn't found an always repeatable cause.

But you should check if there are any macros active (maybe firing by each selection or similar), variables are used in dimensions/expressions but also in captions or other areas (labels, conditions, groups, comments ...) and no functions like now() or today() are applied. Maybe there could be something replaced.

Other reason might be a corrupt application. This meant to recreate the object might not enough - but for checkings I would recreate such object step by step, one dimension and one expression and no further adjustments and look if the happens again and then extend the object slowly with further parts.

Further also the system might cause such behaviour if it run in a VM or if some RAM optimization tools like NUMA are working.

Btw: I would consider to upgrade to a newer Release.

- Marcus

sourabhverma107 · ‎2016-01-11

Thank You Marcus, i have already recreated the chart with same expressions and variables but it doesn't work. Also i tried to recreate the chart with single expression, dimension but this also doesn't work.

So now i will check functions, macros & variables this might be causing the issue.

Thanks,

Sourabh

sourabhverma107 · ‎2016-01-11

Hi Marcus,

Issue is resolved, Now() time-stamp function was creating the issue, so i have used today() function in place of Now() and it worked fine. Thanks for your help.

Thanks,

Sourabh