Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Trigger the values in one field with selection in another field

Hello Experts,

I have a requirement in which I have two list boxes (Or Say Fields) which has no Association between them. My requirement is, when I select multiple values in one list box, the same values should be selected in the other list box also.  Below is the sample code. On selection of multiple "Countries", I want same values to be selected in the "Area".

Note: I want it using triggers only. I don't want to have any association between them.


Country:
LOAD * INLINE [
Country
India
Pak
Zimb
SA
USA
NL
CHINA
CAN
]
;


Area:
LOAD * INLINE [
Area
India
Pak
Zimb
SA
USA
NL
CHINA
CAN
]
;

1.JPG

Thanks In Advance.

Please find the QVW for the reference.

1 Solution

Accepted Solutions
Highlighted

Try this:

=if(GetSelectedCount(Area)=0, '("'&Concat( DISTINCT Area,'"|"')&'")','("' & GetFieldSelections(Area, '"|"', 10000) & '")')

But why use Concat and GetFieldSelections at the same time? Why not sure Concat()?

View solution in original post

22 Replies
Highlighted
Creator II
Creator II

Hi,

Please see the attached app. I have created an variable an put a trigger on selection.

if(GetSelectedCount(Area)<>0, '('&Concat( DISTINCT Area,'|')&')')

Best  regards,

Cosmina

Highlighted

Or even this:

='("' & GetFieldSelections(Area, '"|"') & '")'

Highlighted

why don't you want associations between those fields?

Highlighted
Contributor III
Contributor III

Hello Marco,

Its just the sample data I have given. But my way of implementing it is different. In my datamodel if these two fields are associated, it will form a loop. And I only need to use it in one particular sheet. So I thought this would be the best option.

Highlighted
Specialist
Specialist

You need to also add this condition fr ALL selection (I mean if u select all then all should b selected in othr list box) if u go by Sunny's approach or go with popescu's approach..

It was really informative sunny ,expression helped me in passing multiple values..

Declare variable say: Try

VTotal country==GetSelectedCount(Country)

=if(GetSelectedCount(Country)=$(VTotal country),'*','("' & GetFieldSelections(Country, '"|"') & '")')

Sachin

Highlighted
Contributor III
Contributor III

Hello All,

Thanks for your response. All your inputs are really helpful. But I have a small problem here. I also want to display all the selected values in the text box. It works fine with your inputs but problem comes when I select all the values. Thank you sachin for the scenario you have mentioned. It worked for selection, but not for displaying. Could you help me on that???

Good thing is, I have achieved what I want by combining all the three replies from you guys..

=if(GetSelectedCount(Area)=0, '("'&Concat( DISTINCT Area,'"|"')&'")','("' & GetFieldSelections(Area, '"|"') & '")') 

With the above code in text box, I am getting result "ALL" when everything is selected.

2.JPG

Highlighted
Specialist
Specialist

HI,

Plss attach latest file.

Will modify in text box n give u.

Sachin

Highlighted
Specialist
Specialist

HI,

Do something of this sort and cheat the expression as per need..

=if(GetSelectedCount(Country)=$(VTotal country),Concat(Country,'|'),'("' & GetFieldSelections(Country, '"|"') & '")')

Sachin

Highlighted
Specialist
Specialist

Write above expression in your text box.

It should work..

Sachin