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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

need help if wanna combine 2 condition on section access

Any one could help me on how to combine 2 condition access for country and Business Unit ? i manage to do both if not combine however if i try to combine my qlikview file could't open. please advise on this. Thanks

example code i done:

//UAM: First condition

//LOAD UPPER(ACCESS) AS ACCESS,

//     ATTRIBUTE AS ATTRIBUTE,

//     UPPER(NTNAME) AS NTNAME, 

//     UPPER(DATAVALUE) AS DATAVALUE,

//     IF((ATTRIBUTE)='......',UPPER(DATAVALUE))AS REGION

//FROM

//[..\..\..UAM.xlsx]

//STAR is *;

//Section Access;

//Section_Access:

//LOAD DISTINCT UPPER(ACCESS) AS ACCESS, 

//     UPPER(NTNAME) AS NTNAME,

//     DATAVALUE,

//     UPPER(REGION) AS REGION 

//Resident UAM where ATTRIBUTE='.....';

//Concatenate (Section_Access)

//LOAD * INLINE [     ACCESS, NTNAME, REGION    

//                                  ADMIN, .....                                    ];

//Section Application;

//Access:

//LOAD * INLINE [

//REGION, Country

//CHINA,          China

//..., .....];

//DROP Table UAM;

BU:

LOAD UPPER(ACCESS) AS ACCESS,

     ATTRIBUTE AS ATTRIBUTE,

     UPPER(NTNAME) AS NTNAME, 

     IF((ATTRIBUTE)='......',UPPER(DATAVALUE))AS BU

FROM

[..\..\..\UAM.xlsx]

where ATTRIBUTE='.....';

STAR is *;

Section Access;

Section_AccessBU:

LOAD DISTINCT UPPER(ACCESS) AS ACCESS, 

     UPPER(NTNAME) As NTNAME,

    UPPER(BU) AS BU    

Resident BU where ATTRIBUTE='....';

Concatenate (Section_AccessBU)

LOAD * INLINE [     ACCESS, NTNAME, BU    

                                  ADMIN, ...     ];                               

Section Application;

Access2:

LOAD * INLINE [

BU, 'PPS Business Segments'

PC, PC

HARDWARE,Hardware];

DROP Table BU;

DATA:

LOAD

     //IF(ALIAS='REGION' OR ALIAS='Region',DATAVALUE)AS Country ,

     IF(ALIAS='BU',DATAVALUE)AS [PPS Business Segments] ,

FROM

[..\..\..UAM.xlsx]

SHIP:

LOAD

     COUNTRY as Country,

     [PPS Business Segments],

     REMARKS,

    

FROM

SHIPMENT.xls

0 Replies