Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to share field selections ???

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.

4 Replies
jagan
Partner - Champion III
Partner - Champion III

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.

Not applicable
Author

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
Partner - Champion III
Partner - Champion III

Hi Ravi,

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

Regards,

Jagan.

eddysanchez
Partner - Creator
Partner - Creator

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