Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Like in qlikview with selected field in a list

i have  2 list

one is the list of State

and another is a list which a concatenation of the state and the country

eg

List A

Tamil Nadu

Kerala

Andhra Pradesh

Madhya Pradesh

Maharashta

List B

TamilNadu|India

Kerala|India

Andhra Pradesh|India

Madhya Pradesh|India

Maharashta|India

So now i want to check if the List B like  List A

when i display two list in qlikview

i want to check if the selected item in A 

Like '*ListA*'

can i do that way

5 Replies

Re: Like in qlikview with selected field in a list

See attached example


talk is cheap, supply exceeds demand
Not applicable

Re: Like in qlikview with selected field in a list

i think i was not clear in explainning what i want . let me explain again

i want to get a list /single value using  LIKE

i want to check the list B whose values like '*ListA*' (Selected items in listA)

MVP
MVP

Re: Like in qlikview with selected field in a list

like that?

1.png

Not applicable

Re: Like in qlikview with selected field in a list

have you used LIKE any where ?

amayuresh
Contributor III

Re: Like in qlikview with selected field in a list

Try This,

Script:

1.PNG

UI:

2.PNG

Expression used in second list box:

=if(Index(Comb,right(GetFieldSelections(State),3))>0, Comb)

Community Browser