topic Re: Hide selection in Current Selection Box in QlikView

Hide selection in Current Selection Box

alec1982 — Tue, 20 Nov 2012 18:46:39 GMT

Hi Guys,

I have tried to hide one of the current selection from the current selection box but didn't work!

First I made sure the Show System Field is Deselected.

then I added the following script to load the data

SET HidePrefix = $;

[GMR Variance1]:

LOAD

[GMR Region] ,

[GMR Country] ,

[GMR City] ,

[GMR Data Type] as $SystemField,

RESIDENT

GMR_Data;

it didn't work!

I appreciate any help.

Thxs,

Alec

Re: Hide selection in Current Selection Box

Gysbert_Wassenaar — Tue, 20 Nov 2012 18:59:44 GMT

Try: SET HidePrefix = '$';

Re: Hide selection in Current Selection Box

alec1982 — Tue, 20 Nov 2012 19:10:37 GMT

Hi,

Thanks for the reply. I tried but didn't help.

Thxs,

Re: Hide selection in Current Selection Box

Gysbert_Wassenaar — Tue, 20 Nov 2012 19:31:24 GMT

Sorry, I didn't read your requirement properly. I dont think you can hide a field from the Current Selections box if a value is selected in that field. It looks like hideprefix has nothing to do with that.

Re: Hide selection in Current Selection Box

alec1982 — Tue, 20 Nov 2012 19:36:58 GMT

It does, I have attached a sample where the selected field has Hideprefix value infront of it.and when you select any value it doesn't show in the current selection box.

Not sure why it is not working for me!

he only difference is the load in the attached sample is inline load and mine is from resident table.

Thxs,

Re: Hide selection in Current Selection Box

Gysbert_Wassenaar — Tue, 20 Nov 2012 20:11:18 GMT

Hmm, I must have run into the same problem you have. Unfortunately I have no idea how to reproduce it. The current selection box now indeed doesn't show selections in hide-prefixed fields. Resident load or inline doesn't matter.

Re: Hide selection in Current Selection Box

Tue, 20 Nov 2012 20:56:27 GMT

Try this:

SET HidePrefix = $;

[GMR Variance1]:

LOAD

[GMR Region] ,

[GMR Country] ,

[GMR City] ,

[GMR Data Type] as [$SystemField]

RESIDENT

GMR_Data;

Re: Hide selection in Current Selection Box

erichshiino — Tue, 20 Nov 2012 21:19:24 GMT

Hi,

I tried to open your file but it was blank

I created a qvw where the prefix $ is succesfully hidden

Hope it helps,

Erich

Re: Hide selection in Current Selection Box

alec1982 — Tue, 20 Nov 2012 22:38:50 GMT

this worked correctly! Thxs!