Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to create 4 radio buttons in QlikView. I have read that it can be done using a listbox and then from listbox properties setting presentation to LED.
1) But how to put 4 custom text inside it?
For example I want to create a listbox with this customs texts:
- Make all objects visible
- Make visible object A
- Make visible object B
- Make visible object C
I want above texts (items) to be displayed in the listbox. I want this listbox to be single selection (not multiple selection). These items are not associated to any table field.
2) I would like to modify some variables (IsObjectAVisible, IsObjectBVisible, IsObjectCVisible) value when I click on each listbox item, for example:
try this expression (this is for A)
=substringcount(Concat(l, '|'), 'Make visible object A')
example in the attachment
EDIT: changed the listbox style
Thanks! it works like a charm!
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).
If not, please make clear what part of this topic you still need help with .
Hi, again!
Now I am trying to modify it by making listbox multiselection without " Make all objects visible" option. So my listbox now contains:
- Make visible object A
- Make visible object B
- Make visible object C
and I have modified variables in your example as below:
IsA = if(WildMatch(I, '*object A*'), 1, 0)
IsB = if(WildMatch(I, '*object B*'), 1, 0)
IsC = if(WildMatch(I, '*object C*'), 1, 0)
But when I select more than 1 item in the listbox at the same time is not working. Could you help me, please?
try this expression (this is for A)
=substringcount(Concat(l, '|'), 'Make visible object A')
It works perfectly! Thanks again!