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
Have you accessing the L3 file using Root/Mount folder in QMC or different one. I never face such issue with it
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.
Can you trace using Log files in QMC how many rows it has recorded? So, then we came to know what exactly the issue
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');
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)