topic Re: How to share field selections ??? in QlikView

How to share field selections ???

Thu, 04 Apr 2013 17:56:56 GMT

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.

Re: How to share field selections ???

jagan — Fri, 05 Apr 2013 06:21:50 GMT

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.

Re: How to share field selections ???

Fri, 05 Apr 2013 11:52:16 GMT

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

Re: How to share field selections ???

jagan — Tue, 09 Apr 2013 12:02:11 GMT

Hi Ravi,

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

Regards,

Jagan.

Re: How to share field selections ???

eddysanchez — Tue, 09 Apr 2013 17:37:04 GMT

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