Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
saumyashah90
Specialist
Specialist

i have two columns and want to select a part of the column

I have two columns.

FieldA
223
224
225
226
FieldB
1923_223
1344_224
2343_435
2323_225

When i select 223,

I want 1923_223 to get selected.

Note i can not make additional column , Just a GUI possibility

7 Replies
saumyashah90
Specialist
Specialist
Author

btw both are list box

avinashelite

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)



ganeshreddy
Creator III
Creator III

Hi Saumya,

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.

Regards,

Ganesh

saumyashah90
Specialist
Specialist
Author

i cannot touch the script

saumyashah90
Specialist
Specialist
Author

see i got way to select on value

but i need to see if i can select multiple values

saumyashah90
Specialist
Specialist
Author

see i got way to select on value

but i need to see if i can select multiple values

settu_periasamy

If you want multiple value selection, you can try to use concat.. Like

='('&Concat(DISTINCT '*'&FieldA,'|')&')'

store this into your variable.