Restrict the data values and show always one value

[qlikviewwizard]

Hi All,

I have the status column with the NULL,-,A,B values. But I want to show always only data of STATUS value 'A'.

How to filter or show?

Thanks in advance.

Script:

SALTable:


load *,date(DATE) as Date,
month(date(DATE)) as Month,
'Q' & ceil(month(date(DATE))/3) as Quarter,
year(date(DATE)) as Year;
LOAD * INLINE [


EMPNO,ENAME,JOB,INCHARGE1,INCHARGE2,DATE,SAL,DEPTNO,STATUS
7369,SMITH,CLERK,7902,7566,17-Dec-2015,700,20,A
7369,SMITH,CLERK,7902,7566,17-Dec-2015,900,20,A
7499,ALLEN,SALESMAN,7698,7839,20-Feb-2015,1600,30
7499,ALLEN,SALESMAN,7698,7839,20-Feb-2015,1900,30
7521,WARD,SALESMAN,7698,7839,22-Feb-2015,0,30
7521,WARD,SALESMAN,7698,7839,22-Feb-2015,1650,30
7566,JONES,MANAGER,7839,7698,2-Apr-2015,2975,20,A
7566,JONES,MANAGER,7839,7698,2-Apr-2015,3975,20
7654,MARTIN,SALESMAN,7698,7788,28-Sep-2015,1250,30,A
7654,MARTIN,SALESMAN,7698,7788,28-Sep-2015,2250,30
7698,BLAKE,MANAGER,7839,7698,1-May-2015,2850,30,A
7698,BLAKE,MANAGER,7839,7698,1-May-2015,3850,30,A
7782,CLARK,MANAGER,7839,7566,9-Jun-2015,0,10,B
7782,CLARK,MANAGER,7839,7566,9-Jun-2015,3450,10,B
7788,SCOTT,ANALYST,7566,7782,9-Dec-2015,1250,20,B
7788,SCOTT,ANALYST,7566,7782,9-Dec-2015,4000,20,B
7839,KING,PRESIDENT,NULL,7698,17-Nov-2015,5000,10,A
7839,KING,PRESIDENT,NULL,7698,17-Nov-2015,6000,10,A
7844,TURNER,SALESMAN,7698,7788,8-Sep-2015,1500,30,B
7844,TURNER,SALESMAN,7698,7788,8-Sep-2015,2500,30,B
7876,ADAMS,CLERK,7788,7698,12-Jan-2015,1100,20,B
7876,ADAMS,CLERK,7788,7698,12-Jan-2015,2100,20,B
7900,JAMES,CLERK,7698,7566,3-Dec-2015,950,30,-
7900,JAMES,CLERK,7698,7566,3-Dec-2015,650,30,-
7902,FORD,ANALYST,7566,7782,3-Dec-2015,3000,20,A
7902,FORD,ANALYST,7566,7782,3-Dec-2015,2000,20,A
7934,MILLER,CLERK,7782,7782,23-Jan-2015,1300,10,A
7934,MILLER,CLERK,7782,7782,23-Jan-2015,300,10,A
];

[swuehl · Accepted solution]

If you want to filter in the load script:

LOAD * INLINE [

...

] WHERE STATUS = 'A';

Or select A in your list box and then use lock option in list box properties. This will keep all records in your data model, so you can change your mind on the fly.

[qlikviewwizard]

Thank you swuehl.