topic Re: Trigger the values in one field with selection in another field in QlikView

Trigger the values in one field with selection in another field

avinashkk696 — Wed, 25 Nov 2020 16:16:04 GMT

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
];

Thanks In Advance.

Please find the QVW for the reference.

Re: Trigger the values in one field with selection in another field

Anonymous — Mon, 13 Feb 2017 14:31:39 GMT

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

Re: Trigger the values in one field with selection in another field

sunny_talwar — Mon, 13 Feb 2017 14:36:40 GMT

Or even this:

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

Re: Trigger the values in one field with selection in another field

MarcoWedel — Mon, 13 Feb 2017 23:03:55 GMT

why don't you want associations between those fields?

Re: Trigger the values in one field with selection in another field

avinashkk696 — Tue, 14 Feb 2017 06:12:43 GMT

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.

Re: Trigger the values in one field with selection in another field

sdmech81 — Tue, 14 Feb 2017 07:37:41 GMT

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

Re: Trigger the values in one field with selection in another field

avinashkk696 — Tue, 14 Feb 2017 09:29:17 GMT

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.

Re: Trigger the values in one field with selection in another field

sdmech81 — Tue, 14 Feb 2017 09:40:09 GMT

HI,

Plss attach latest file.

Will modify in text box n give u.

Sachin

Re: Trigger the values in one field with selection in another field

sdmech81 — Tue, 14 Feb 2017 09:43:39 GMT

HI,

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

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

Sachin

Re: Trigger the values in one field with selection in another field

sdmech81 — Tue, 14 Feb 2017 09:45:41 GMT

Write above expression in your text box.

It should work..

Sachin

Re: Trigger the values in one field with selection in another field

avinashkk696 — Tue, 14 Feb 2017 10:01:47 GMT

Hello Sachin,

Please find the below attachment. I am getting the value. But I also need inverted comas("") also. I tried modifying. If it works in one way, it is not working in the other way. Please have a look at the same.

Re: Trigger the values in one field with selection in another field

sunny_talwar — Tue, 14 Feb 2017 10:11:13 GMT

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()?

Re: Trigger the values in one field with selection in another field

sdmech81 — Tue, 14 Feb 2017 10:37:46 GMT

HI,

Plss try like this:

Create variable like vShow=''&'("'& Concat(Country,'"|"')&'")'&

and then pass that vShowas shown below..It works

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

Sachin

Re: Trigger the values in one field with selection in another field

sdmech81 — Tue, 14 Feb 2017 10:40:37 GMT

Hi Sunny,

If u use get filed selection and select all in list box..It ll show ALL.

And avinash wants it to be shown as all values rather than ALL string.

So created variable to check fr all n done like this.Thanks

Sachin

Re: Trigger the values in one field with selection in another field

sunny_talwar — Tue, 14 Feb 2017 10:46:06 GMT

Did you look at my response above?

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

I have also attached a sample to look at.

Re: Trigger the values in one field with selection in another field

Anonymous — Tue, 14 Feb 2017 10:47:42 GMT

Hi all, While using the concat function, in the current selections its showing the expression like (Value1|Value2|...). Can we avoid this and display in the current selections like it will do when a normal selection is done.

Thanks in advance.

Re: Trigger the values in one field with selection in another field

sdmech81 — Tue, 14 Feb 2017 11:17:28 GMT

Hi,

@ Shiva only....R u continuing Avinash's thread r separate one..

If separate,then normal expression something like:

=GetFieldSelections(Country)

would give u how current selection gives u the data..

Sachin

Re: Trigger the values in one field with selection in another field

sdmech81 — Tue, 14 Feb 2017 11:20:45 GMT

FYI, Avinash

The above expressions can b done using either concat() or even with GetFieldSelections() to bring that (" ")..

Hope its done?

Sachin

Re: Trigger the values in one field with selection in another field

avinashkk696 — Tue, 14 Feb 2017 12:19:17 GMT

Hello Sunny,

Thanks a lot. Your expression did work well. But could you explain me what that "10000" means over there for my future reference??

Re: Trigger the values in one field with selection in another field

sunny_talwar — Tue, 14 Feb 2017 12:23:38 GMT

GetFieldSelection has an upper limit of how many selected value it shows before it starts to aggregate the selections. In order to expand the upper limit, you can provide this additional parameter which will tell your expression to not aggregate until 10000 or 10000000.

Also, check these links out:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/FieldFunctions/getfieldselections.htm‌

Missing Manual - GetFieldSelections() + Bonus Example