Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
geogou1973
Creator
Creator

Problem with the data in a section access qvw

Hello i have the following script in the Sec Tab

Section Access;

LOAD * INLINE [

ACCESS, NTNAME

ADMIN, DOMAINNAME\USERNAME1

USER, DOMAINNAME\USERNAME2

];

Section Application;

STAR IS *;

LOAD * INLINE [

NTNAME, CSECAR

DOMAINNAME\USERNAME1, *

DOMANINAME\USERNAME2, 10

];       


I have checked also in the Document Properties and the tab Opening the following



Opening.png


In some cases i am losing data. Did i do anything wrong with the script or the options that i have checked in the opening tab ?


Thank you in advance.


25 Replies
swuehl
MVP
MVP

Could you detail a bit more the scenarios where you are losing data?

I've had some issues with the STAR IS ...; statement in the past, so I generally try to avoid it.

Instead, I create explicite associations in the table.

see also

A Primer on Section Access

Basics for complex authorization

Authorization using a Hierarchy

marcus_sommer
MVP & Luminary
MVP & Luminary

I think there is nothing wrong with your settings but your used wildcard of "*" in CSECAR won't mandatory cover all records. Are there for example NULL's within this fields they will be excluded by the opening reduction of the application. An indicator for this is if you opened the application as admin (who should see all data) and try to save the application without a reload - if you get a SaveAs dialog for this any data-reduction has happens.

- Marcus

krishnacbe
Partner
Partner

Hi

* will include all the data in the inline statement and not the full list from DB or anyother source.

you need to join the distinct values from table to the section access table so that all the values will be included for Admin.

explain in detail about what data you lose.

- Krishnapriya

geogou1973
Creator
Creator
Author

Hello Marcus.

I discover that some data does not much with the CSECAR because is null. When i open the QVW from the server and before save it the data are correct. When i save and i open the qvw from the explorer i have the problem with the data that have no CSECAR. How can i avoid this problem ?

marcus_sommer
MVP & Luminary
MVP & Luminary

For this you need to replace the NULL's with a real value like 'NULL' or '#NV' and it will be depend on how these NULL's are created which way will be suitable to catch them. Maybe a simple if-loop like:

if(len(trim(CSECAR))=0'#NV', CSECAR) as CSECAR

will be enough. If not have a look here: NULL handling in QlikView.

- Marcus

geogou1973
Creator
Creator
Author

Hello swuehl.

I discovered that some data does not much with the CSECAR because is null. When i open the QVW from the server and before save it the data are correct. When i save and i open the qvw from the explorer i have the problem with the data that have no CSECAR. How can i avoid this problem ?

Not applicable

Hello there,Could this be a problem with the values and the comparison with Uppercase against the Lowercase?

swuehl
MVP
MVP

QlikView can only link values, not NULL.

And section access' reduction mechanism is based on linking fields in section access and section application.

If you want more help, you would need to describe a bit more detailed how your values in the reduction fields look like.

geogou1973
Creator
Creator
Author

Hello.

I have two tables. The one the table for the items and the other is the table for the sales.

The table for the items has the item number and the barcode and the CSECAR (the first level of the category of the item). The table for the sales has the barcode and sales qty and sales amount. The data for the sales are uploading for the stores. In this table some times there are barcodes that are not included in the table of the items because are from the collection of franchise stores. For this reason the data are not matching and do not have CSECAR the field is null and with section access in the script we are losing them.

With which way can i avoid this problem ?

Thank you in advance