topic Re: table row count different reload vs restart in QlikView

table row count different reload vs restart

Thu, 19 Feb 2015 17:22:01 GMT

I'm getting different row counts when I reload the app vs. when I exit and restart the app.

The table viewer shows identical table views and table attributes.

The app performs correctly with the "after reload" set.

I've removed all actions.

Why would the table row counts be different? I would expect them to be the same.

Any hints on what I should look at to solve this?

Edited:

bump & minor reformatting.

John

11.20 SR9

Re: table row count different reload vs restart

Colin-Albert — Thu, 19 Feb 2015 19:39:49 GMT

Reloading on the desktop may not be set to save the app after the reload.

Have you tried reloading the data, saving the app, then closing and re-opening.

Re: table row count different reload vs restart

Thu, 19 Feb 2015 19:52:56 GMT

Colin,

Thanks for the suggestion, but unfortunately that did not change my results.

John

Re: table row count different reload vs restart

Anonymous — Thu, 19 Feb 2015 19:58:59 GMT

John,

Can you give up a bit more detail on where you are experiencing this? Are you on the server when you close and restart? If you are in the desktop version, reloading will then cause your selections to clear out. If you close and then reopen you may have selections that are remaining.

Hopefully that helps?

-Chris

Re: table row count different reload vs restart

Colin-Albert — Thu, 19 Feb 2015 20:02:34 GMT

Does the document have Section Access?

Re: table row count different reload vs restart

Thu, 19 Feb 2015 20:03:01 GMT

follow-up:

I moved the app to a QV test server and accessed it via the Access Point and the row count matches the reload row count.

This sort of resolves the row count oddity.

John

Re: table row count different reload vs restart

Thu, 19 Feb 2015 20:03:47 GMT

re: Section access - Yes it does. Would that make a difference?

Re: table row count different reload vs restart

Colin-Albert — Thu, 19 Feb 2015 20:04:10 GMT

On a server the app will be saved on completion of the reload.

Re: table row count different reload vs restart

Thu, 19 Feb 2015 20:05:58 GMT

Chris,

I'm doing app-dev of this particular app on the QV (test) server and doing my reloads on the server.

I've also see this same behavior for another app on my desktop.

John

Re: table row count different reload vs restart

Thu, 19 Feb 2015 20:08:13 GMT

Clarification / Correction - this app was always on the server.

I moved the app to a partition on the server that could be accessed by the Access Point.

John

Re: table row count different reload vs restart

Colin-Albert — Thu, 19 Feb 2015 20:33:10 GMT

Yes, section access will make a difference.

On the server, the QDS service account must be given full access in the Section Access script to ensure all data is loaded. If not then the server will only load the data it has been given permission to see.

Also it depends on whether the options for "Initial Data Reduction on Open" and "Strict Exclusion" are set, and who then opens the document. This will apply any data restrictions set in the section access script for that user.

Re: table row count different reload vs restart

Thu, 19 Feb 2015 20:45:16 GMT

Colin,

Thank you.

Un-checking "Initial Data Reduction ..." fixed the app problem.

Now to see if this affects the security settings.

John

Re: table row count different reload vs restart

Colin-Albert — Thu, 19 Feb 2015 20:51:16 GMT

I would suggest you add the service account to section access, and set the field permissions correctly so the service account can access all data, and then re-enable the "Initial Data Reduction" option.

The data reduction is how Section Access removes data users do not have permission to see, thus giving the data security.