Hide the object -List box always one selected value

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

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?

Re: Hide the object -List box always one selected value

rubenmarin — Tue, 30 Jun 2015 14:16:40 GMT

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;

Re: Hide the object -List box always one selected value

qlikviewwizard — Tue, 30 Jun 2015 14:31:54 GMT

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;

Can we hide this one as well?

Re: Hide the object -List box always one selected value

rubenmarin — Tue, 30 Jun 2015 14:38:15 GMT

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

What exactly you want to hide?

Re: Hide the object -List box always one selected value

qlikviewwizard — Tue, 30 Jun 2015 14:57:13 GMT

Hi RubenMarin,

Fantastic. You are great. Thank you so much

topic Re: Hide the object -List box always one selected value in QlikView

Hide the object -List box always one selected value

Re: Hide the object -List box always one selected value

Re: Hide the object -List box always one selected value

Re: Hide the object -List box always one selected value

Re: Hide the object -List box always one selected value