Change Dimension

[mmainiero]

Hi,

is it possible to get the Selection for "alpha" in one Field and Transfer the Information to another?

The content of alpha and beta is identical. For example "Smith, "Miller", "Armstrong".

=Aggr(only({OWN} alpha),alpha)

=Aggr(only({OTHER} beta),beta)

[Zhandos_Shotan · Accepted solution]

Hi

Try this to ways:

1) use selected alpha values as beta's filter

=Aggr(only({<beta=P(alpha)>} beta),beta)

OR

2) using another key field and search condition:

=Aggr(only({<RowID={"=alpha=beta"}>} beta),beta)

Regards

[Sue_Macaluso]

@mmainiero Hi, are you using QlikView or Sense?  I would like to move this into the correct product forum. Thank you

[mmainiero]

Qlikview