How to create a selection list from the values contained in the script.

[Anonymous]

Hello I'm new to qlikview, I would like to know how to create a selection list from the values contained in a script. I explain myself I have a set of fields with values (as in the table viewer below) and I wish that from a selection list I can highlight the histogram of the fields including #taux_resolution by example.

thank you for your reactions.

[Anonymous]

I would like to delete the fields % entities_name and annee from the selection list below.

[Anonymous]

[rubenmarin]

For that particular case you can use:

=If(not Match($Field,'%entities_name','annee'), $Field)

[Anonymous]

Ruben, now it adds an entities_id column and it does not delete anything or hide the fields I want.

[Anonymous]

[rubenmarin]

I don't see %entities_name or annee in that list...You can check how match works:

https://help.qlik.com/es-ES/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFun...

Add the fields you want to omit or load the list of field names in a field and use the expression I posted before.

[Anonymous]

Here are all the lines I would like to remove from the selection list.

when i use match () it does not give what i want.

please help me.

[rubenmarin]

Hi Franck, I would need a sample to check what's happening.

[sasiparupudi1]

Hi may be use HidePrefix varible in script and rename your fields with a specific prefix like a % or an _

in the script on the top you may declare the special variable like

set HidePrefix=%;

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/SystemVariable...

[Anonymous]

it does not work