Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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

Re: Issue in QV reload

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

Re: Issue in QV reload

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

Re: Issue in QV reload

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

Re: Issue in QV reload

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

Re: Issue in QV reload

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
Contributor II

Re: Issue in QV reload

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

sudeepkm
Valued Contributor III

Re: Issue in QV reload

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

Re: Issue in QV reload

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

Re: Issue in QV reload

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?

Community Browser