Set Analysis - {}

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

Hi,

In my expression I am trying to do a CONCAT with set analysis. I have two loaded tables not connected to each other.

ID_1	Data
123	100
456	200

ID_2	Type
123	AAA

User first selects an ID_1. There should then be a straight table showing ID_1 and Type.

So what I've done is create a Straight Table with Dimension = ID_1 and Expression is CONCAT({<ID_2=ID_1>}Type). The set analysis isn't working. But basically I want to get [Type] from the other table where ID_2 is equal to the selected ID_1.

Note that I cannot rename ID_2 as ID_1 in the load because ID_2 does not consistently refer to ID_1. For other rows ID_2 contains values for other types of ID's.

Resulting Straight Table:

ID_1	Type
123	AAA

Re: Set Analysis - {}

sunny_talwar — Mon, 16 Apr 2018 01:10:16 GMT

May be this

Concat({<ID_2 = P(ID_1)>} Type)

Re: Set Analysis - {}

Anonymous — Tue, 17 Apr 2018 12:14:59 GMT

Thanks Sunny. The above from experience seems to work occasionally. For this instance, I decided not to use set analysis and just tried:

=Concat(if(ID_2=ID_1,ActivityName))

and worked okay.

topic Re: Set Analysis - {<FieldA=FieldB>} in QlikView

Set Analysis - {}

Re: Set Analysis - {}

Re: Set Analysis - {}