topic Re: field from listbox in variable in QlikView

field from listbox in variable

amien — Tue, 08 Mar 2016 12:06:40 GMT

is it possible to read the field which is used in the listbox into a variable?

Having alot of listboxes in the dashboard.

I created an excel with all the fields and a flag. This flag represents show or do not show.

Now i want to use this flag in the Show Condition feature in the listbox.

Only({<AdvancedField = {FieldName}>} AdvancedFlag) = 1

I want to replace "FieldName" with the current field in the listbox, in order to have the same line in each listbox.

Is this possible, or does someone have a better solution?

sunny_talwar — Tue, 08 Mar 2016 12:08:35 GMT

May be this:

Only({<AdvancedField = p(ListBoxFieldNameHere)>} AdvancedFlag) = 1

amien — Tue, 08 Mar 2016 12:11:47 GMT

"ListBoxFieldNameHere"

QlikView should read this from the current object. I don''t want to fill in the listboxname here manually.

Only({<AdvancedField = {$(vCurrentListBoxField}}>} AdvancedFlag) = 1

How can i fill vCurrentListBoxField

MayilVahanan — Tue, 08 Mar 2016 12:12:16 GMT

Are you looking like this

SubField(GetCurrentSelections(),':', 1)

sunny_talwar — Tue, 08 Mar 2016 12:14:02 GMT

Well what I am saying is that the fieldname you want to pick from is fixed, right? You just need to add that between p()

Only({<AdvancedField = p(ListBoxFieldNameHere)>} AdvancedFlag) = 1

swuehl — Tue, 08 Mar 2016 12:14:20 GMT

Try

=Only({<AdvancedField = {'$(=GetObjectField (0))'}>} AdvancedFlag) = 1

amien — Tue, 08 Mar 2016 12:27:14 GMT

For some reason .. when i past this in the title .. it works. It will show a 0 or 1

But when i use this in Show Condition, it does nothing

amien — Tue, 08 Mar 2016 12:52:58 GMT

My bad .. i needed to add an additional condition. It works

Thanks

swuehl — Tue, 08 Mar 2016 12:54:55 GMT

Seems to work for me, using a limited setting (basically just checking if GetObjectField() gets evaluated in the show condition).

Could you upload a small sample QVW with your setting?