topic Re: Transfer selections from one field to another in App Development

Transfer selections from one field to another

RAMK — Sat, 16 Nov 2024 19:06:07 GMT

Hi everyone,

I have a data model having two fields "CustomerName" & "Customer", the two fields hold the same data but are not linked and i cannot link them due to other considerations in my data model.

i want to transfer user selections from one field to another. for example, user selects XYZ and ABC in "CustomerName", i want XYZ and ABC to be selected in "Customer" field.

I know its possible with getselections in QlikView but cannot get it to work in Qlik Sense.

your help is appreciated,

Thanks

Re: Transfer selections from one field to another

jonathandienst — Tue, 18 Feb 2020 05:45:10 GMT

Use this in set expression:

Sum({<Customer = P(CustomerName), ....

Re: Transfer selections from one field to another

RAMK — Tue, 18 Feb 2020 08:44:36 GMT

Thanks Jon,

This will force me to change set analysis of all expressions. Yet it is a good fall back solution if I couldn't achieve a transfer of selection which will reflect on all expressions.

Thanks

Re: Transfer selections from one field to another

ShellyG — Thu, 17 Dec 2020 11:13:45 GMT

Hi Jonathan,

I am trying to accomplish something very similar to what this topic was about. I have two calendars (there is a good reason why they are separated) and I want when a selection is made in one of them, the same selection to be made in the other calendar...

I am not sure I understand the solution though, as I tried something like YEAR1=P([YEAR2]) in a set expression, but it doesn't seem to be properly working... Can you please explain more on how to achieve this?

Thanks a lot!