Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue in QV reload

Hi all,

I am facing the following issue in a application.

I reload a application and I get my salesvalue as, say for example 9 billion.

Then I save and close the application.When I open the same application, I get salesnumbers as 7 billion.

What does this mean?

Kindly help me on this issue.

Thanks in advance,

Regards,

Vidhya

9 Replies
Not applicable
Author

reloading through desktop? have you got section access applied?

It sounds like you dont have access to all the data, as section access is applied on open not after reload

sudeepkm
Specialist III
Specialist III

Do you have any document level or sheet level trigger set and as a result some filter selection is occurring and the values being shown as 7bn?

In that case when you reopen the file then look at the current selection box just to make sure if it is not the impact of any selections.

It would be good if you can attach the file for verification.

Not applicable
Author

Hi Vidhya,

What is the source for your data and is the source data residing on your server?

Also is there a reload job running on your server for this?

Thanks

Sabal

Not applicable
Author

I did a reload in server, yes section access is applied in the application.

I have included Link Table in the application,

Will this happen anytime because of any issue in LinkTable?

Thanks & Regards,

Vidhya

Not applicable
Author

Datasource is in the server only, there is no job running in the server for this.

Section access is applied in the application, both before and after reload, current selections are the same.

Thanks & Regards,

Vidhya

marksmunich
Creator III
Creator III

Just check out if there is a trigger or filter applied on any of the dimensions which is influencing your revenue.

sudeepkm
Specialist III
Specialist III

I do not think link table is causing the problem because even after the link table you are able to see 9bn when you open the document and save it.

I think now that section access might have impact on it.

One quick question. When you said that "I reload a application and I get my salesvalue as, say for example 9 billion."

Can you pls tell whether section access was applied that time or it is just a full reload in your local system?

Not applicable
Author

Hi Sudeep,

I implemented Link Table concept in my application, then gave a reload, after reload, 9 billion bookings is seen, I saved and closed the application, when I open the closed application again, I am getting 7 billion as bookings, In both cases, section access was applied.

Thanks,

Vidhya

sudeepkm
Specialist III
Specialist III

Even if you have section access applied but you reload the document then the whole data gets reloaded ignoring the section access. That's the reason we add Publisher Functional ID in the section access table as Admin so that the reload will be full data.

Section Access is applied when you open the document. Remember one thing that Section Access ignores the null entries of the Field used in the section access table.

So can you please make sure that the field name based on which you are reducing data from the document does not have null values.

Can you please post screenshot of your Section Access Table?