Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
there is a problem
set access rights. when opening a report, data is lost, you load the script appear - save report - when opening a report, data is lost
Can you help?
security settings in the document properties are set correctly.
problem appeared not long ago
we refer to the file
After downloading the script all is well
after opening the document, the information lost
I can not understand why cuts data when opening a document, but after loading all available
we have a slightly different system admin - one user
try
STAR IS *;
before section access statement
You say:
But this is how Section Access should work. Section Access reduces data when you open the file. But it doesn't affect what is loaded in the script run.
If you think that Section Access (after you open file) remove too much data, then you need to debug e.g. by commenting the Section Access statement (but keeping the load of the Access table). It could be a mismatch between field values in the Access table and in the real data.
See also http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/26/section-access
HIC
do not understand where you want to put *
thank you
Just insert first line
STAR IS *;
before Section Access; words
This will not work.
First of all, the star symbol is not very good to use as wildcard, since it will not cover all possible values. It will only match other values found in Section Access. For example, in Marina's Section Access, ЦФО can be 1 or 2. This means that the star will match these two, but it will not match 3 and 4 if these should be found in data.
Further, the demand is to reduce over two fields: БЕ and ЦФО. The demand is
(БЕ = {1,2,3} AND ЦФО = {any value}) OR (БЕ = {any value} AND ЦФО = {1,2})
but this is not how QlikView will interpret your Access table.
See more here: http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/02/data-reduction-using-multiple-fields
HIC
STAR IS *;
did not help
in code
Upper(ACCESS) as ACCESS
Upper(NTNAME) as NTNAME
then apply star is *;
hope this helps
I agree with http://community.qlik.com/people/hic
it shouldn't work.
Try to see http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/02/data-reduction-using-multiple-fields