Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
HAmzehAF
Partner - Creator
Partner - Creator

Help


SECTION ACCESS;
Authorization:
LOAD * INLINE [
ACCESS, USER.EMAIL, DIV_CODE

USER, fayis@per.com, 52
USER, fayis@per.com, 53
USER, fayis@per.com, 71

 

];
SECTION APPLICATION;

LOAD
DIV_CODE,
Division
FROM [lib://DataFiles/Qlik Sense - Untitled - Table - July 24, 2024.xlsx]
(ooxml, embedded labels, table is Sheet1);


im doing this and when i login to the user i go to the sheet but no data is showing at all ? any help with this 

this is my sales the thing it should show 

LOAD 
distinct 
DOCNO,
   text(TRXH_LOC_CODE) as TRXH_LOC_CODE,
    Channel,
    DIVISION as DIV_CODE,
  CATEGORY as GROUP_CODE ,
 CATEGORY&'-'&Group As Group_Name,
    SUPP_CODE,
    Supplier,
 PRODUCT,
    Product,
    BRAND,
    Brand,
    "Date",
    Year,
    Month,
    Day,
    DateNum,
     TIME,
 
FROM [lib://One .com.kw/xxx_Daily3Days.qvd]
(qvd)WHERE "TRXH_LOC_CODE" <> '101';
 
 
 



Labels (4)
1 Reply
BrunPierre
Partner - Master II
Partner - Master II

Hi, temporarily remove the WHERE clause and section access to see if the data loads correctly without restrictions. Also, display the DIV_CODE  to ensure data is correctly loaded and associated.