Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Hide selection in Current Selection Box

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

1 Solution

Accepted Solutions
Not applicable

Try this:

SET HidePrefix = $;

[GMR Variance1]:

LOAD

[GMR Region] ,

[GMR Country] ,

[GMR City] ,

[GMR Data Type] as [$SystemField]

RESIDENT

GMR_Data;

View solution in original post

8 Replies
Gysbert_Wassenaar

Try: SET HidePrefix = '$';


talk is cheap, supply exceeds demand
alec1982
Specialist II
Specialist II
Author

Hi,

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

Thxs,

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
alec1982
Specialist II
Specialist II
Author

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,

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable

Try this:

SET HidePrefix = $;

[GMR Variance1]:

LOAD

[GMR Region] ,

[GMR Country] ,

[GMR City] ,

[GMR Data Type] as [$SystemField]

RESIDENT

GMR_Data;

erichshiino
Partner - Master
Partner - Master

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

alec1982
Specialist II
Specialist II
Author

this worked correctly! Thxs!