Discussion Board for collaboration on QlikView Scripting.
Need guidance in writing Script in QVW (Where source is QVD) similar like Case Statement in SQL. Please below Query and modify below case statement.
Section Access; /* Start section access script */
CASE WHEN [EMP NAME] IN ('SHIVENDOO KUMAR','RAM KUMAR')THEN 'ADMIN' ELSE 'USER' END AS ACCESS,
[EMP NAME] AS USERID,
[EMP NAME] AS PASSWORD,
EMP_KEY AS _EMP_KEY
FROM DIM_EMP_DATA.QVD (qvd);
Section Application; /* End section access script */
Another question I have in mind, in Above Section Query I have defined [EMP NAME] as USERID & PASSWORD. So If User Name is with White space like SHIVENDOO KUMAR , in this case will it work or not?
Go to Solution.
If(match([EMP NAME],'SHIVENDOO KUMAR','RAM KUMAR'),'ADMIN','USER')