topic Re: Hide selected values from selection box in QlikView

Hide selected values from selection box

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

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.

Re: Hide selected values from selection box

MK_QSL — Tue, 30 Jun 2015 14:20:33 GMT

What is source1 and source2?

Re: Hide selected values from selection box

qlikviewwizard — Tue, 30 Jun 2015 14:23:34 GMT

Hi MRKachhiaIMP,

source1 - SALTable

source2 - COMMTable

Re: Hide selected values from selection box

MK_QSL — Tue, 30 Jun 2015 14:33:00 GMT

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.

Re: Hide selected values from selection box

qlikviewwizard — Tue, 30 Jun 2015 14:40:25 GMT

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.

Re: Hide selected values from selection box

Tue, 30 Jun 2015 14:42:35 GMT

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

Re: Hide selected values from selection box

MK_QSL — Tue, 30 Jun 2015 14:54:12 GMT

Create Alternate State

Use ALTERNATE STATE 1 For EMPNO1 and DEPTNO

Use ALTERNATE STATE 2 for EMPNO2 and DEPTNO

Re: Hide selected values from selection box

jagan — Tue, 30 Jun 2015 15:08:22 GMT

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.

Re: Hide selected values from selection box

jagan — Tue, 30 Jun 2015 15:09:21 GMT

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.

Re: Hide selected values from selection box

qlikviewwizard — Tue, 30 Jun 2015 15:25:51 GMT

Thank you jagan