
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Tags:
- qmc
- reload data
- « Previous Replies
- Next Replies »
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have you accessing the L3 file using Root/Mount folder in QMC or different one. I never face such issue with it

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you have section access in your app by any chance?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI Anil ,
i didnt know wht you are exactly asking i am new to this if u guide me will describe it

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you trace using Log files in QMC how many rows it has recorded? So, then we came to know what exactly the issue

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Since it is the Binary Load how can i check how many data are loaded

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Good question , I don't know... I have never done this before... loveisfail any ideas? May be pcammaert can help?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)

- « Previous Replies
- Next Replies »