topic Re: value selected list box in QlikView

value selected list box

patrou38 — Tue, 25 Apr 2017 09:22:02 GMT

hello,

I would like to select a value in list box based on the result o fa variable.
It doesn't work , nothing are selected

if ($(vNameChart)='Test Configuration', Lib_Testeur='titi',Lib_Testeur='toto')

thank you again for your help.

Patrick

Re: value selected list box

sunny_talwar — Tue, 25 Apr 2017 09:27:35 GMT

Are you using select in field trigger here? Assuming the field name is Lib_Testeur where you are making selection, try this

FieldName

Lib_Testeur

Search String

If($(vNameChart)='Test Configuration', 'titi', 'toto')

Re: value selected list box

patrou38 — Tue, 25 Apr 2017 09:41:45 GMT

no Is not in the select in filed but in the dimension..

I tried this: =if ($(vNameChart)='MMS Reference Test Configuration',Lib_Site='Spore')

but I get an error : "Garbage after expression: 'MMS...'

Re: value selected list box

sunny_talwar — Tue, 25 Apr 2017 09:46:48 GMT

May be try this

=If($(vNameChart)='MMS Reference Test Configuration',

If(Lib_Site='Spore', Lib_Site))

Re: value selected list box

patrou38 — Tue, 25 Apr 2017 09:48:42 GMT

I don't want to put or have a condition on Lib_Site list box, but I would like to Select field in this one 😉

Re: value selected list box

sunny_talwar — Tue, 25 Apr 2017 09:50:18 GMT

I am not sure I understand you sir.... May be if you can share a sample where you are seeing an issue and point it out to us....

Re: value selected list box

patrou38 — Tue, 25 Apr 2017 09:56:06 GMT

in the picture below You can see a list box "Lib_Site.

if my Variable equal ok I would like to select automatically "Spore" in the list box otherwise no choice .

is it more clear ?

Re: value selected list box

sunny_talwar — Tue, 25 Apr 2017 10:00:44 GMT

You want to select in a list box or do you want to have it as a calculated dimension? These are two different things... List box selection can be done using select in field action... where as calculated dimension uses if conditions.... but I am not clear as to how a calculated dimension needs to select in a list box? They are two different objects

Re: value selected list box

patrou38 — Tue, 25 Apr 2017 11:47:22 GMT

ok . I will do my select thru the select in field function -)

thank you for all

Patrick