Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
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
rubenmarin

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
rubenmarin

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;

qlikviewwizard
Master II
Master II
Author

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?

rubenmarin

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

What exactly you want to hide?

qlikviewwizard
Master II
Master II
Author

Hi RubenMarin,

Fantastic. You are great. Thank you so much