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]

Hi,

Not sure, if I understand your question, but, you can try this:

Recipe for a Histogram

Histogram example

Regards,

[Anonymous]

Actually, when I click on create a list of selection its load the variables of the fields and nevertheless I want rather than its load the fields.

[rubenmarin]

Hi Franck, there is a system field called $Field wich stores the names of the fields.

In a table box you can check the option to 'Show system fields'. This option is enabled/disabled for the whole document. Once activated, in a List Box you can select the $Field field.

Also in a list box you can slect '<expression>' and check the option to 'Show system fields', but you need to reopen the List box to see the system field in the drop-down.

[sudhirpkuwar]

Can you be more specific about how you want the output to be...?

[Anonymous]

Hi Ruben,now I have seen, but how to remove the fields that we do not want and how to do so that the other fields do not disappear when we click on a field.

[Anonymous]

As a selection list with fields and not variables.

exemple.

mydimension(title)

taux_satisfaction

taux_reparation

taux_protection

in a selection list.

[rubenmarin]

If it dissapears can be because you are using a Table box, with a List box it shouldn't dissapear.

[Anonymous]

how to remove the fields that we do not want

[rubenmarin]

I'm not sure what you meant with that.

If you want a list of specific fields you will need an inline table or external file with the fields you want and filter the $field values in List Box expression:

=If(Match($Field,$(=Chr(39) & Concat(FieldNameList_Field, Chr(39) &','& Chr(39)) & Chr(39))), $Field)

If not please post a sample and the expected result.