Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to hide the object of the List box always one selected value.
It will filter the entire data model. How to achieve this?
Hi, you want to hide the list box? why not remove the object?
or you want to hide the selections in current selections? You can use HidePrefix in script and rename the field using that prefix:
Set HidePrefix ='%';
Rename field DEPTNO to%DEPTNO;
Hi, you want to hide the list box? why not remove the object?
or you want to hide the selections in current selections? You can use HidePrefix in script and rename the field using that prefix:
Set HidePrefix ='%';
Rename field DEPTNO to%DEPTNO;
I am able to remove from the current selections.
I applied the filer DEPTNO=30 value for entire data model and this is default and compusory selection. Thats is I want to hide.
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 [
EMPNO1,ENAME,JOB,INCHARGE1,INCHARGE2,DATE,SAL,DEPTNO
7369,SMITH,CLERK,7902,7566,17-Dec-2015,700,20
7369,SMITH,CLERK,7902,7566,17-Dec-2015,900,20
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
7566,JONES,MANAGER,7839,7698,2-Apr-2015,3975,20
7654,MARTIN,SALESMAN,7698,7788,28-Sep-2015,1250,30
7654,MARTIN,SALESMAN,7698,7788,28-Sep-2015,2250,30
7698,BLAKE,MANAGER,7839,7698,1-May-2015,2850,30
7698,BLAKE,MANAGER,7839,7698,1-May-2015,3850,30
7782,CLARK,MANAGER,7839,7566,9-Jun-2015,0,10
7782,CLARK,MANAGER,7839,7566,9-Jun-2015,3450,10
7788,SCOTT,ANALYST,7566,7782,9-Dec-2015,1250,20
7788,SCOTT,ANALYST,7566,7782,9-Dec-2015,4000,20
7839,KING,PRESIDENT,NULL,7698,17-Nov-2015,5000,10
7839,KING,PRESIDENT,NULL,7698,17-Nov-2015,6000,10
7844,TURNER,SALESMAN,7698,7788,8-Sep-2015,1500,30
7844,TURNER,SALESMAN,7698,7788,8-Sep-2015,2500,30
7876,ADAMS,CLERK,7788,7698,12-Jan-2015,1100,20
7876,ADAMS,CLERK,7788,7698,12-Jan-2015,2100,20
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
7902,FORD,ANALYST,7566,7782,3-Dec-2015,2000,20
7934,MILLER,CLERK,7782,7782,23-Jan-2015,1300,10
7934,MILLER,CLERK,7782,7782,23-Jan-2015,300,10
];
COMMTable:
LOAD * INLINE
[
EMPNO2,COMM
7369,150
7499,300
7521,
7566,150
7654,1400
7698,150
7782,
7788,200
7839,200
7844,0
7876,200
7900,200
7902,200
7934,300
];
Set HidePrefix ='%';
Rename field DEPTNO to %DEPTNO;
!
Can we hide this one as well?
If there will be always that value selected, why not removing the object?
What exactly you want to hide?
Hi RubenMarin,
Fantastic. You are great. Thank you so much