Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

Restrict the data values and show always one value

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

];

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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.

View solution in original post

2 Replies
Highlighted
MVP
MVP

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.

View solution in original post

Highlighted
Master II
Master II

Thank you swuehl.