topic transfer selection from multiple states to one state in QlikView

transfer selection from multiple states to one state

suryaa30 — Tue, 26 Sep 2017 10:46:53 GMT

Hi All,

I have below Alternate states

Alt_A,Alt_B,Alt_C

Currently I am transferring selections in Alt_A to Alt_C as show below.

Now I want both transfer selections made in both Alt_A and Alt_B together in Alt _C.

How should I manipulate the below expression.

='('&Concat({Alt_A}DISTINCT Replace([BankName],' ','?'),'|')&')'

Anil_Babu_Samineni — Tue, 26 Sep 2017 10:53:39 GMT

how about this?

='('&Concat({Alt_A * Alt_B}DISTINCT Replace([BankName],' ','?'),'|')&')'

suryaa30 — Tue, 26 Sep 2017 10:54:27 GMT

Is this intersection? I am expecting a union.

A= 1,2,3

B=4,5,

then 1,2,3,4,5 should be transferred

I came up with this.. will this do?

='('&Concat({Alt_A<Fecha+=P({Alt_B})>}DISTINCT Replace([BankName],' ','?'),'|')&')'

Anil_Babu_Samineni — Tue, 26 Sep 2017 11:03:17 GMT

For Union u need to specify +

Anil_Babu_Samineni — Tue, 26 Sep 2017 11:05:10 GMT

Try this?

='('&Concat({Alt_A<Fecha+=P({Alt_B} Fecha)>}DISTINCT Replace([BankName],' ','?'),'|')&')'

sunny_talwar — Tue, 26 Sep 2017 11:17:09 GMT

How about this

='('&Concat({Alt_A + Alt_B}DISTINCT Replace([BankName],' ','?'),'|')&')'

suryaa30 — Tue, 26 Sep 2017 11:18:06 GMT

I used +