topic Re: Hide fields from current selections. in QlikView

Hide fields from current selections.

Tue, 09 Jun 2015 13:32:56 GMT

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.

Re: Hide fields from current selections.

alexandros17 — Tue, 09 Jun 2015 13:35:48 GMT

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

Re: Hide fields from current selections.

vcanale — Tue, 09 Jun 2015 13:36:02 GMT

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

];

Re: Hide fields from current selections.

swuehl — Tue, 09 Jun 2015 13:36:17 GMT

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.

Re: Hide fields from current selections.

Tue, 09 Jun 2015 13:52:34 GMT

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

Re: Hide fields from current selections.

Tue, 09 Jun 2015 13:53:25 GMT

Im not sure i inderstood.

I atached an example

Thank you, greetings.

Re: Hide fields from current selections.

jonathandienst — Tue, 09 Jun 2015 13:55:12 GMT

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.....

Re: Hide fields from current selections.

swuehl — Tue, 09 Jun 2015 13:56:09 GMT

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..

Re: Hide fields from current selections.

alexandros17 — Tue, 09 Jun 2015 13:56:15 GMT

Here is it