Solved: table row count different reload vs restart - Qlik Community

Report Inappropriate Content · ‎2015-02-19

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

Colin-Albert · ‎2015-02-19

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.

View solution in original post

Colin-Albert · ‎2015-02-19

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.

Report Inappropriate Content · ‎2015-02-19

Colin,

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

John

Anonymous · ‎2015-02-19

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

Colin-Albert · ‎2015-02-19

Does the document have Section Access?

Report Inappropriate Content · ‎2015-02-19

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

Report Inappropriate Content · ‎2015-02-19

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

Colin-Albert · ‎2015-02-19

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

Report Inappropriate Content · ‎2015-02-19

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

Report Inappropriate Content · ‎2015-02-19

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