Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try
=Only({<AdvancedField = {'$(=GetObjectField (0))'}>} AdvancedFlag) = 1
May be this:
Only({<AdvancedField = p(ListBoxFieldNameHere)>} AdvancedFlag) = 1
"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
Hi
Are you looking like this
SubField(GetCurrentSelections(),':', 1)
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
Try
=Only({<AdvancedField = {'$(=GetObjectField (0))'}>} AdvancedFlag) = 1
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
My bad .. i needed to add an additional condition. It works
Thanks
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?