topic Re: Data loss after reload in QlikView

Data loss after reload

saimahasan — Wed, 15 Feb 2017 06:06:18 GMT

Hi,

I need urgent help on my problem.

I have an application which when i reload gives proper data but when i save it close it and reopen it the data from the data model gets reduced.

I am not able to figure out what's the reason behind this

Please suggest

Re: Data loss after reload

Chanty4u — Wed, 15 Feb 2017 06:08:17 GMT

Hi,

Do you have a section access in your application?

if yes

comment that and reload the same

Re: Data loss after reload

saimahasan — Wed, 15 Feb 2017 06:11:38 GMT

But i need section access in my application

Re: Data loss after reload

saimahasan — Wed, 15 Feb 2017 06:12:52 GMT

AFAIK section access will reduce data in the frontend. Right???

But i could see very less data in Table viewer

Re: Data loss after reload

Chanty4u — Wed, 15 Feb 2017 06:22:32 GMT

yes. did you checked without section access ?

is it working properly?

Re: Data loss after reload

saimahasan — Wed, 15 Feb 2017 06:47:30 GMT

In section access, i have admin rights so ideally i should get to see all the data. But i could not see any data. And table viewer gives me surprising view

Re: Data loss after reload

pavanthota — Wed, 15 Feb 2017 07:00:39 GMT

Have you checked the all the columns in the table having the same data . What i mean whatever the column you are showing in the table it might contain few rows having duplicates in the data

Please check if that is the case use recno() function while loading

Please find the below files for your reference

Thanks,

Pavan

Re: Data loss after reload

sdmech81 — Wed, 15 Feb 2017 07:02:14 GMT

Its bcs of section access.

Upon reload u ll see full data but but section access is really effected when u close it and reopen the application.

If u r supporting tht doc..U need to get admin access, I mean full access to data.

Do u have access to section access script??

Sachin

Re: Data loss after reload

saimahasan — Wed, 15 Feb 2017 09:19:46 GMT

Thanks to all for your replies. Issue is resolved now.

Re: Data loss after reload

Chanty4u — Wed, 15 Feb 2017 09:21:50 GMT

what you have made to get the solution/?

Re: Data loss after reload

sdmech81 — Wed, 15 Feb 2017 09:23:36 GMT

Wt was the issue BTW??

Sachin