topic Re: use getfieldselections to assign multiple values to another field in QlikView

use getfieldselections to assign multiple values to another field

Thu, 29 Aug 2013 13:11:24 GMT

Hi guys,

i have 2 fields journey_type and bm_journey type.

whenever a user select value/values in journey type, i want the same values to be selected in bm_journey type.

All is well when only one value need to be assigned.

but when multiple value is selected in field, it is not working

i used both triggers and macro

Trigger : for journey type-> on select and change -> select in field -> bm journey_type -> getfieldselections(journey_type)

and in MACRO as follows...

ActiveDocument.Fields("bm_journey_type").Select ActiveDocument.Evaluate("Getfieldselections(journey_type)"), True

please suggest whats wrong or some alternate methods to achieve this.

Re: use getfieldselections to assign multiple values to another field

fernando_tonial — Thu, 29 Aug 2013 13:22:04 GMT

hi, you can try in your trigger.

Select in field = bm_journey type

='('& Concat(getfieldselections(journey_type),'|') &')'

The result is:

(Value1|Value2|Value3)

Best Regards.

Tonial.

Re: use getfieldselections to assign multiple values to another field

jfkinspari — Thu, 29 Aug 2013 13:22:10 GMT

You can achieve this by expression level by utilizing set analysis

sum({$<bm_journey type = journey_type >} FieldToSum)

It requires that at least one value is selected in journey_type

Re: use getfieldselections to assign multiple values to another field

lironbaram — Thu, 29 Aug 2013 13:27:53 GMT

hi attach is an example

Re: use getfieldselections to assign multiple values to another field

Thu, 29 Aug 2013 13:40:28 GMT

Hi i tried this code,

it works for single values but not for multiple values.

also my use of this function is to compare two set of tables , of which one has journey_type and one set of values and the other having bm_journey_type.

And each of fields can have 3 distinct values one_way, r_trip and multi_city

in your code also, when only one is selected, the values are selected in bm_journey_type,

but when 2 of them say oneway and rtrip are selected, its not working,

any modificaitons???

Re: use getfieldselections to assign multiple values to another field

fernando_tonial — Thu, 29 Aug 2013 13:59:44 GMT

Sorry, remove de function getfieldselections().

='('& Concat(journey_type,'|') &')'

Best Regards.

Tonial.