How to share field selections ???

[#1]

Hello,

I'm trying to create an relationship between two fields without alter the data structure on my QVW.

Exemple:

TABLE1 (

FIELD_A

);

TABLE2 (

FIELD_B

);

When i select FIELD_A i want to transfer the selections to the FIELD_B too.

[Data structure too big to alter and merge this columns]

Can anyone help me? Probably i should use a macro, right?

Using Qlikview 9!

Thanks.

[jagan]

Hi,

If FIELD_A and FIELD_B has same values then renaming FIELD_B to FIELD_A simply solves the problem, it establishes the relation between two tables like this

TABLE1:

LOAD

FIELD_A

FROM Datasource1;

TABLE2:

LOAD

FIELD_B AS FIELD_A

FROM Datasource2;

If you don't want to maintain the relation between the tables and selections of FIELD_A to be included in FIELD_B then use the following  expressions in all the places like this

Sum({<FIELD_B={$(=If(GetSelectedCount(FIELD_A) > 0, Concat(DISTINCT FIELD_A, ','), '*'))}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

[#3]

really help me thanks

iam the learner of qlikview

please brother can u tel me ur contact number

iam from andhrapradesh ,

how is the market for qlikview,

please brother reply me for this post.

Regards

Ravi

09742243997

[jagan]

Hi Ravi,

I too from AP, Market for Qlikview is very good, I will call you later.

Regards,

Jagan.

[eddysanchez]

For pass the selection you need to go to:

Setting > Document properties > Triggers

select the corresponding field and configure an action OnChange and OnSelect like Select in field with the corresponding value