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: 
Not applicable

Hide fields from current selections.

Hi everybody

I'm used to use inline tables with IDs to hide/show graphs and tables (I use the conditional). I don't like the buttons.

But now, my client don't like this because in the current selections he can see all this fields selected

Is there any way to hide 'x' fields from the current selections?

Thank you

Greetings.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You can still use the field for selections in a list box. Change your script to

Set HidePrefix = '_';

LOAD * INLINE [

   _Table, Id_Table

    Table1, 1

    Table2, 2

];

And look what happens..

View solution in original post

8 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Use HidePrefix() instruction (Take a look at the help ...)

vcanale
Partner - Creator II
Partner - Creator II

Hi Jeremias,

SET HidePrefix='_' ;
and use the underscore before the field name in the INLINE table,

eg:

LOAD * INLINE [

_Fieldname, vValue

Opt1, vValue1

Opt2, vValue2

];

swuehl
MVP
MVP

Use a prefix (or suffix) for the fields and then set HidePrefix variable accordingly in the script.

This will hide the fields from current selection box, like system fields.

Not applicable
Author

But i dont understand.

If i use this can i use this see the list table?

Here an example of what i wanna do.

Greetings

Not applicable
Author

Hi

Im not sure i inderstood.

I atached an example

Thank you, greetings.

jonathandienst
Partner - Champion III
Partner - Champion III

You can see the list table, and you can see the fields in the dialogs if you enable system fields, but you wont see the fields in the current selection box.

Set HidePrefix = %;

LOAD Field1 As %Field1, Field2 As %Field2.....

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
swuehl
MVP
MVP

You can still use the field for selections in a list box. Change your script to

Set HidePrefix = '_';

LOAD * INLINE [

   _Table, Id_Table

    Table1, 1

    Table2, 2

];

And look what happens..

alexandros17
Partner - Champion III
Partner - Champion III

Here is it