Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to hide the object of the current selection box
I have sheet1,sheet2 and source1,source2.
When I select 2nd source values shows in first sheet which I used first source.
How to achieve this? Thanks in advance.
Hi,
You can hide that field from Current Selections box by using the
Set HidePrefix ='%';
LOAD
*,
DEPTNO to%DEPTNO
FROM DataSource;
If you want to hide other fields also just rename it to %FieldName pattern. Then this will not show in Current Selections box.
Hope this helps you.
Regards,
Jagan.
What is source1 and source2?
Can you clarify little more on your requirements?
Not understood below !
When I select 2nd source values shows in first sheet which I used first source.
EMPNO1,DEPTNO are from source 1.
EMPNO2 is from source2.
I want to hide EMPNO2 from sheet1 current selections.
EMPNO1,DEPTNO from sheet2 current selections.
Given that your sources are separate, trial using "Alternate States".
Create Alternate State
Use ALTERNATE STATE 1 For EMPNO1 and DEPTNO
Use ALTERNATE STATE 2 for EMPNO2 and DEPTNO
Hi,
You can hide that field from Current Selections box by using the
Set HidePrefix ='%';
LOAD
*,
DEPTNO to%DEPTNO
FROM DataSource;
If you want to hide other fields also just rename it to %FieldName pattern. Then this will not show in Current Selections box.
Hope this helps you.
Regards,
Jagan.
The same way you can also use HideSuffix, check examples below from Qlikview help file.
All field names beginning with this text string will be hidden in the same manner as the system fields. A user-defined variable.
Example:
set HidePrefix='_' ;
If this statement is used, the field names beginning with an underscore will not be shown in the field name lists when the system fields are hidden.
All field names ending with this text string will be hidden in the same manner as the system fields. A user-defined variable.
Example:
set HideSuffix='%';
If this statement is used, the field names ending with a percentage sign will not be shown in the field name lists when the system fields are hidden.
Thank you jagan