Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
laurischarf
Contributor II

Mysteriously disappearing data

My app in Sense Enterprise 3.2 starts out well, after the data load, and shows 37,143 patients in a KPI. I'll work in the app and edit it, and all is well. I'll come back to it after an absence (and I likely have to log back into Sense), and the patient count will be down to 29,851. No filters are applied. I can work in it and everything appears to work normally, but the patient count stays at 29,851.

To add to the mystery, when I look at the data model viewer after this has happened, it shows the field in question as having a "Total distinct values" count of 37,143! So the underlying dataset appears to be intact. But the app's web page does not reflect it.

I'll add that the app loads data into 21 tables. The patient ID is a key field.

This problem has occurred a number of times now this week, always with the same change to 29,851.

Thanks for any insights.

4 Replies
annapochyla
New Contributor III

Re: Mysteriously disappearing data

Hi,

do you use section access in your app?

Anna

laurischarf
Contributor II

Re: Mysteriously disappearing data

Hi,

Yes, section access is based on an organizational ID (ORGID).

Thanks,

Lauri    

annapochyla
New Contributor III

Re: Mysteriously disappearing data

Did you checked, if it is not the section access fault? Maybe it limit's the data?

laurischarf
Contributor II

Re: Mysteriously disappearing data

Hi Anna,

I've been working as an admin, with access to all ORGID values. I also tried reloading data without any section access. The problem doesn't seem related to section access.

Thanks,
Lauri