Discussion Board for collaboration related to QlikView App Development.
I have two columns.
When i select 223,
I want 1923_223 to get selected.
Note i can not make additional column , Just a GUI possibility
If you want 1923_223 to get selected when 223 is selected , then you need to build a relation for it and you cannot achieve in this easily in the front end .
Try like this :
Subufield(fieldB,'_',2) as FieldA
in front end try like this if(FieldA=Subufield(fieldB,'_',2),FieldB)
If two fields are from same tables try to create a new field in script as mentioned below, then in list box make a concatenated field.
1. In script : Subufield(FieldB,'_',2) as FieldC
2. In list box expression (Make a concatenated field) : FieldA&'_'&FieldC
i hope it works.