topic Re: How to create a selection list from the values contained in the script. in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

Anonymous — Thu, 26 Apr 2018 17:35:58 GMT

Hi,

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

Recipe for a Histogram

Histogram example

Regards,

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

Anonymous — Fri, 27 Apr 2018 06:29:36 GMT

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.

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

rubenmarin — Fri, 27 Apr 2018 07:06:18 GMT

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.

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

sudhirpkuwar — Fri, 27 Apr 2018 07:10:22 GMT

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

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

Anonymous — Fri, 27 Apr 2018 07:44:10 GMT

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.

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

Anonymous — Fri, 27 Apr 2018 07:51:50 GMT

As a selection list with fields and not variables.

exemple.

mydimension(title)

taux_satisfaction

taux_reparation

taux_protection

in a selection list.

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

rubenmarin — Fri, 27 Apr 2018 07:56:59 GMT

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

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

Anonymous — Fri, 27 Apr 2018 09:09:31 GMT

how to remove the fields that we do not want

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

rubenmarin — Fri, 27 Apr 2018 09:22:28 GMT

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.

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

Anonymous — Fri, 27 Apr 2018 09:35:51 GMT

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

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

Anonymous — Fri, 27 Apr 2018 09:37:50 GMT

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

rubenmarin — Fri, 27 Apr 2018 09:46:43 GMT

For that particular case you can use:

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

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

Anonymous — Fri, 27 Apr 2018 10:30:17 GMT

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

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

Anonymous — Fri, 27 Apr 2018 10:48:02 GMT

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

rubenmarin — Fri, 27 Apr 2018 11:21:34 GMT

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/ConditionalFunctions/match.htm

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

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

Anonymous — Fri, 27 Apr 2018 13:22:51 GMT

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.

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

rubenmarin — Mon, 30 Apr 2018 18:38:51 GMT

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

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

sasiparupudi1 — Mon, 30 Apr 2018 18:47:16 GMT

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/SystemVariables/HidePrefix.htm

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

Anonymous — Wed, 02 May 2018 10:59:47 GMT

it does not work