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

Hide the object -List box always one selected value

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?

Capture.JPG

Capture1.JPG

1 Solution

Accepted Solutions
Highlighted

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;

View solution in original post

4 Replies
Highlighted

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;

View solution in original post

Highlighted
Master II
Master II

RubenMarin

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;

Capture.JPG !

Can we hide this one as well?

Highlighted

If there will be always that value selected, why not removing the object?

What exactly you want to hide?

Highlighted
Master II
Master II

Hi RubenMarin,

Fantastic. You are great. Thank you so much