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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
pacoli2013
Creator
Creator

If Else Statement

Hello,

I'm build an Access Control in a Qlikview Document like:



Star is *;

// SECTION Access;

// SUPER ADMIN
LOAD * INLINE [
    ACCESS, USERNAME, PASSWORD, MARKER_COMPANIES, MARKER_DATALEVEL,MARKER_SELLTOCUSTOMER, MARKER_EXCLUDINGINVOICENUMBER, MARKER_EXCLUDINGITEMS, MARKER_COMPANY, MARKER_DIVISION, MARKER_SALESDISTRICT, MARKER_CUSTOMER
    ADMIN, QADMIN, QADMIN, ALL, ALL, ALL, ALL, ALL, ALL, ALL, ALL, ALL
    ];

LOAD
      if (ALLDIMENSIONVALUESALLOWED = '-1', 'ADMIN', 'USER') as ACCESS,
      USERNAME,
      PASSWORD,

if  (REPORTINGALLOWANCEDEMENSION_PK = '1') then (DIMENSIONVALUEALLOWED as MARKER_COMPANY);
elseif  (REPORTINGALLOWANCEDEMENSION_PK = '3' ) then DIMENSIONVALUEALLOWED as MARKER_DIVISION;
   elseif  (REPORTINGALLOWANCEDEMENSION_PK = '5' ) then DIMENSIONVALUEALLOWED as MARKER_SALESDISTRICT;
     else DIMENSIONVALUEALLOWED as MARKER_CUSTOMER;
ENDIF

//      PK,
//      REPORTINGUSERPK,
//      REPORTINGALLOWANCEDEMENSION_PK,
//      DIMENSIONVALUEALLOWED,
//      DIMENSIONVALUEVAILEDFROM,
//      DIMENSIONVALUEVAILEDTO,
//     DIMENSIONNAME,
//     ISACTIVE,
//     DEFTABLESCHEMA,
//     DEFTABLENAME,
//     DEFVALUECOLNAME
From (qvd);

exit script;

The Problem I have is the if .... else Statement: it does not work

the Messages I get are :

Syntax Fehler: FROM fehlt/falsch:

LOAD

      if (ALLDIMENSIONVALUESALLOWED = '-1', 'ADMIN', 'USER') as ACCESS,

      USERNAME,

      PASSWORD

if  (REPORTINGALLOWANCEDEMENSION_PK = '1') then (DIMENSIONVALUEALLOWED as MARKER_COMPANY)

LOAD

      if (ALLDIMENSIONVALUESALLOWED = '-1', 'ADMIN', 'USER') as ACCESS,

      USERNAME,

      PASSWORD

if  (REPORTINGALLOWANCEDEMENSION_PK = '1') then (DIMENSIONVALUEALLOWED as MARKER_COMPANY)

and

Fehler in Skriptzeile:

elseif  (REPORTINGALLOWANCEDEMENSION_PK = '3' ) then DIMENSIONVALUEALLOWED as MARKER_DIVISION

etc.

I hope that someone can help me and has a solution for my problem

Thanks in advance

0 Replies