topic Re: Inconsistent Data in QlikView

Inconsistent Data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a question about inconsistent data shown in straight table.

I have about 60 column in my straight table (10 dimension and 50 expression).

When i open the application via browser for the first time, it shows correctly on its column. But when i click refresh on the browser, some expression data (value) move from one column to another column (let's say column A to column B). When i cut the number of expression column from 50 to 30, the issue is solved.

My question is, is it a bug from qlikview ?

FYI, i already restart qlikview server & services and clear the browser cached.

Really need your help.

Thanks in advance

Re: Inconsistent Data

gajapathy74 — Tue, 25 Oct 2016 10:36:03 GMT

‌

Please refer this thread, may be useful. maximum number of columns in an object

Re: Inconsistent Data

Anonymous — Tue, 25 Oct 2016 10:45:28 GMT

Hi,

Thanks for your reference.

In my case, the problem is not about load performance.

But the "inconsistent" data, and it's only happen when i open the app from browser. When i click refresh button, the data value move from one column to another column, although i have put set analysis inside it.

When i cut the number of expression, the problem solved.

But i need some explanation about this problem.

Thanks in advance.

Re: Inconsistent Data

migueldelval — Tue, 25 Oct 2016 10:56:39 GMT

Hi Chou,

How many rows are you showing?

Maybe you can check how many Symbols in Charts are allowed.

Regards

Miguel del Valle

Re: Inconsistent Data

Anonymous — Wed, 26 Oct 2016 00:47:59 GMT

Hi Miguel,

Thanks for the answer.

I have selected one item only from the selection, so there is only one row shown.

Can you explain about the symbol limitation ?

Thanks in advance.

Really appreciate your help

Re: Inconsistent Data

rwunderlich — Wed, 26 Oct 2016 02:03:31 GMT

Are you refreshing the browser right away, or after a period of time (where they may have been a session timeout).

Can you upload a sample that shows the problem?

-Rob

Re: Inconsistent Data

Anonymous — Wed, 26 Oct 2016 03:06:36 GMT

I'm refreshing the browser after the data shown, i directly click the refresh button on the browser. After the refresh finish the data is missing (sometimes move to another column and sometimes become zero),

I've try to restart the server and clear the browser cache but the problem still exist.

Unfortunately i can't share the sample, because the problem happen in web client side (browser) and working fine in QV developer application.

FYI i've try using two different browser, IE9 and google chrome.

Thanks in advance.

Re: Inconsistent Data

Anil_Babu_Samineni — Wed, 26 Oct 2016 03:09:20 GMT

If you multiply with other it will occurs. So. Try to share same file with us or logfile atleast

Re: Inconsistent Data

rwunderlich — Wed, 26 Oct 2016 16:50:52 GMT

If you can share the qvw, we can try it in a server to see if I can recreate. You can scramble any sensitive fields.

-Rob