Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Contributor II

## Un-associated fields

Good day,

I have two tables (say Table_A and Table_B) in my application which contains Company Names Company_From_A and Company_From_B, respectively.

(Given that Company Names (data) available in Table_A is also available in Table_B).

One of visualization page contains two charts, Chart_A associated with Table_A company names and Chart_B associated with Table_B company names.

Now my issue is with filter pane where I used only one dimension Company_From_A, on selection reflects dissociated data in Chart_B.

Is it possible to control both the charts by using single dimension (say Company_From_A) on selection, reflects changes in Char_B.

In simple words, Selection from Company_Name_AAuto Selects Company_Name_B.

Script function solution is highly appreciated.

Note: Being a newbie, This is my first question on Qlik community. Please let me know if I missed any thing from my question.

1 Solution

Accepted Solutions
Specialist III

In your measure try to use P() function some thing like

Sum({<Company_Name_B = P(Company_Name_A)>}Sales)

HTH

5 Replies
Contributor II
Author

# Chart function solution is highly appreciated

Creator III

Share sample data and app

Specialist III

In your measure try to use P() function some thing like

Sum({<Company_Name_B = P(Company_Name_A)>}Sales)

HTH

Contributor II
Author

Thank you KCH, currently applied an alternate solution which is working fine. I will also take a shot with P(). If things didn't work for me, will post my alternate solution here.

Contributor II
Author

Sum({<Company_Name_B = P(Company_Name_A)>}Sales) - Working like charm (as exactly wanted).

Alternately I created variable and called it set analysis.

vSelected_Companies=GetFieldSelections(Company_Name_A)

Measure:

if(GetSelectedCount(Company_Name_A)>0,

Sum({<Company_Name_B={'\$(vSelected_Companies)'},Company_Name_A=>}Sales),

Sum(Sales)

Tags
Community Browser