Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Lauri
Specialist
Specialist

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
Partner - Contributor III
Partner - Contributor III

Hi,

do you use section access in your app?

Anna

Lauri
Specialist
Specialist
Author

Hi,

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

Thanks,

Lauri    

annapochyla
Partner - Contributor III
Partner - Contributor III

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

Lauri
Specialist
Specialist
Author

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