Hide selected values from selection box

[qlikviewwizard]

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.

[MK_QSL]

What is source1 and source2?

[qlikviewwizard]

Hi MRKachhiaIMP,

source1 - SALTable

source2 - COMMTable

[MK_QSL]

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.

[qlikviewwizard]

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.

[#6]

Given that your sources are separate, trial using "Alternate States".

[MK_QSL]

Create Alternate State

Use ALTERNATE STATE 1 For EMPNO1 and DEPTNO

Use ALTERNATE STATE 2 for EMPNO2 and DEPTNO

[jagan · Accepted solution]

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.

[jagan]

The same way you can also use HideSuffix, check examples below from Qlikview help file.

HidePrefix

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.

HideSuffix

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.

[qlikviewwizard]

Thank you jagan