Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
suryaa30
Contributor II

transfer selection from multiple states to one state

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],' ','?'),'|')&')'

BankName.PNG

1 Solution

Accepted Solutions

Re: transfer selection from multiple states to one state

how about this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

6 Replies

Re: transfer selection from multiple states to one state

how about this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

suryaa30
Contributor II

Re: transfer selection from multiple states to one state

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],' ','?'),'|')&')'

Re: transfer selection from multiple states to one state

For Union u need to specify +

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: transfer selection from multiple states to one state

Try this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: transfer selection from multiple states to one state

How about this

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

suryaa30
Contributor II

Re: transfer selection from multiple states to one state

I used +