Discussion board where members can get started with QlikView.
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;
View solution in original post
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.
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 [
LOAD * INLINE
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?
Fantastic. You are great. Thank you so much