Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Issue in Data Reload

Hi ,

I have 12000 record in the database and it is displaying 12,000 record in Level2 file

When i manually reload the L3 file in the Qlikview it is showing all the 12,000 record

When the Refresh is done in QMC it is Showing only 2000 Records instead of 12000

Please help me out  with this issue

stalwar1marcowedelkaushik.solankiloveisfailmarcus_sommerluismadrizjonnieyacoub

27 Replies
Highlighted

Have you accessing the L3 file using Root/Mount folder in QMC or different one. I never face such issue with it

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

Do you have section access in your app by any chance?

Highlighted
Creator
Creator

Hi Sunny ,

I didnt find the Section Access with the Application

but in QMC it is having the AD group in the Summary

Kindly guide me with this issue

Highlighted
Creator
Creator

HI Anil ,

i didnt know wht you are exactly asking i am new to this if u guide me will describe it

Highlighted

Can you check the logfile to see how many rows of data got loaded in? I have not used AD groups, but it might be connected to Section Access somehow. Not really sure about that.

Highlighted

Can you trace using Log files in QMC how many rows it has recorded? So, then we came to know what exactly the issue

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator
Creator

Since it is the Binary Load how can i check how many data are loaded

Highlighted

Good question , I don't know... I have never done this before... loveisfail‌ any ideas? May be pcammaert‌ can help?

Highlighted

Sure sunny, When Binary Loads involves as you stated there may be restrict data which (Section Access) - So he stated he didn't use that.

My thoughts are May be some filter happens like Where condition before Binary Load like ETL Transaction to get there requirement. But, He said something Development getting all records and QMC not. That means there is some thing related to Active Directory concepts implemented using Data Restriction for specific reason.

Ok, He must respond and/or check all the Log files which needed to be done. So, I suggest him to Trace Functionality to get into work like with in Binary Load it self that means Final Table.

LET Sample = NoOfRows('Sample');

Trace $(Sample);

Once it got present, Use that variable into Text box to know how many records got knowing. May be screenshots also will help in Dashboard and Same object using from QMC too (Which obtain in Access point)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)