Restrict the data values and show always one value

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

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

];

Re: Restrict the data values and show always one value

swuehl — Sat, 27 Jun 2015 12:16:50 GMT

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.

Re: Restrict the data values and show always one value

qlikviewwizard — Sat, 27 Jun 2015 14:12:31 GMT

Thank you swuehl.

topic Restrict the data values and show always one value in QlikView

Restrict the data values and show always one value

Re: Restrict the data values and show always one value

Re: Restrict the data values and show always one value