I have below load script , it work fine when the script is reload on my note book OSUser = DESKTOP-9837GT0\pauly. When i implement this script on my Qlik View note book OSUser = QV-PC\QV , it will not work. because when i open the document , i only can view SOURCE = TS and not all SOURCE.
LOAD * INLINE [
ACCESS, NTNAME, SOURCE
LOAD * INLINE [
Below image shown that when reload on my note book , i can view SOURCE = TS TA SD LE , When reload by another note book QV-PC\QV, when i open the QVW file , i only can view SOURCE = TS ( Which is not correct )
Can some one advise me where go wrong ?
The point here is ADMIN need to have the full access to perform data reduction.
If you restrict ADMIN to view only TS, the rest of the user can only view TS Data.
Unless you specify ADMIN to view all.
Either you specify the ADMIN to view all, or you add another ADMIN(eg: the service account used for installation) and provide it the authority to view all.
Log in with the service account and reload the dashboard.
Thank you very much , now i am clear . Just To sum up :-
For admin note book , i must create like below :-
If i log into the above note book , and do reload and save the Doc , the above note book is admin.
So the rest of the note book , for example below right for my note book :-
Thank you once again.
i have one related question , when i using below script , i can only view SOURCE=TS :-
When i using below script , it work fine :-
Amy advise to me , why i cannot use "*" for view all SOURCE ?
Taking this as example:
The * here refers to only TS, because * refers to 'All' in the resident table.
Since you have only TS in this table, * refers to only TS.
Now the * refers to TS and TA.
My question is refer to your example 2 below :-
Why i cannot replace by below :-
Any advise on this ? So that i don't need to write duplicate 9 line of script.