topic Re: Issue in Data Reload in QlikView

Issue in Data Reload

Anonymous — Tue, 23 Jan 2018 12:42:46 GMT

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

stalwar1‌marcowedel‌kaushik.solanki‌loveisfail‌marcus_sommer‌luismadriz‌jonnieyacoub‌

Re: Issue in Data Reload

Anil_Babu_Samineni — Tue, 23 Jan 2018 12:46:11 GMT

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

Re: Issue in Data Reload

sunny_talwar — Tue, 23 Jan 2018 12:47:55 GMT

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

Re: Issue in Data Reload

Anonymous — Tue, 23 Jan 2018 12:56:59 GMT

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

Re: Issue in Data Reload

Anonymous — Tue, 23 Jan 2018 12:58:07 GMT

HI Anil ,

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

Re: Issue in Data Reload

sunny_talwar — Tue, 23 Jan 2018 12:58:41 GMT

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.

Re: Issue in Data Reload

Anil_Babu_Samineni — Tue, 23 Jan 2018 13:00:24 GMT

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

Re: Issue in Data Reload

Anonymous — Tue, 23 Jan 2018 13:26:17 GMT

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

Re: Issue in Data Reload

sunny_talwar — Tue, 23 Jan 2018 13:31:37 GMT

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

Re: Issue in Data Reload

Anil_Babu_Samineni — Tue, 23 Jan 2018 13:43:04 GMT

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)

Re: Issue in Data Reload

Peter_Cammaert — Tue, 23 Jan 2018 13:46:17 GMT

The QVW that is being displayed in your AccessPoint (and that is possibly also reduced), is available in your Document root (or in the distribution folder if you have a Publisher). Open it in QV Desktop and check Settings->Document Properties->Tables. Objects in the UI cannot be reliably used to report on the number of rows in your internal tables.

Re: Issue in Data Reload

Anonymous — Tue, 23 Jan 2018 14:21:42 GMT

HI I am attaching the file section access used in the App

stalwar1‌ Anil Babu

Re: Issue in Data Reload

Anonymous — Tue, 23 Jan 2018 14:26:26 GMT

section access have been used in the Application Sunny

Re: Issue in Data Reload

Peter_Cammaert — Tue, 23 Jan 2018 14:40:29 GMT

Your Section Access code hints at the usage of Data Reduction. That's probably why you don't see all rows that were initially loaded by the load script. When oopening the document in the AccessPoint, every user defined in the Section Access table will get a reduced view of the document according to which link values exist in the document for the identified user.

Re: Issue in Data Reload

Anonymous — Tue, 23 Jan 2018 14:43:33 GMT

is any chance to retrive all the data

Re: Issue in Data Reload

Anonymous — Tue, 23 Jan 2018 14:44:41 GMT

i am into the Admin Group for me also it is reducing the Data

but when i refreshed the QVW file within Qlikview i am able to see the File

Re: Issue in Data Reload

Peter_Cammaert — Tue, 23 Jan 2018 14:44:52 GMT

Also note that there is no ADMIN role in the AccessPoint. Everybody is treated as a USER. The main difference is that in QV Desktop your account may be recognised as an ADMIN and you can possibly see all data by default (i.e. not because Section Access says so), but there is no such behavior in the AccessPoint.

Re: Issue in Data Reload

Anonymous — Tue, 23 Jan 2018 14:48:38 GMT

i thought this Code for Admin:

ADMINUser:

LOAD

'PHARMA\'&''&upper(NTLOGIN) as ADMIN_NTNAME

FROM $(vQVD)Dim_User_Mapping.qvd (qvd)

where not isnull(TRIMMENTITYID) and isnull(BUID) and isnull(PRODUCTID) and GEOGRAPHYID = '-9999';

TMP:

LOAD CONCAT(CHR(39) & ADMIN_NTNAME & CHR(39),',') AS ADMIN_NTNAME1

RESIDENT ADMINUser;

LET vADMINNTNAME = PEEK('ADMIN_NTNAME1',0);

//=======

TST1:

LOAD distinct concat(Chr(39)&NTNAME&Chr(39),',') as USER1

Resident Security

Where ACCESS = 'USER'

and wildmatch(upper(NTNAME),$(vADMINNTNAME))=0;

Correct me if i am Wrong

And kindly help me out how can i retrive all the Record into the Table for User

Re: Issue in Data Reload

Peter_Cammaert — Tue, 23 Jan 2018 14:51:56 GMT

If you want to retrieve all data in the document view in the AP, you'll have to make sure that the Section Access entry for your account links to everything in your data model. This is usually done by defining a link field with a value like 'ALL' instead of one or more existing values in your data sources, and in Section Application you can create this artificial value and link it to everything.

Or you could disable "Strict Exclusion". But that's a bit of a brute force method as it applies to everyone who can get in but doesn't have proper link values. Maybe not your preferred technique...

Re: Issue in Data Reload

Peter_Cammaert — Tue, 23 Jan 2018 14:55:57 GMT

Can you explain what this code does? It doesn't ring a bell.
Retrieve all record for user. See above (previous post)

Of course, first you have to make sure that your final QVW really does contain all 12000 records. Did you do the check of your published document in QV Desktop yet?