Un-associated fields

[zulfikar_syed]

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_A =  Auto 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.

[zulfikar_syed]

Sorry about asking the script function. I need a chart function

Chart function solution is highly appreciated

[ChennaiahNallani]

Share sample data and app

[kkkumar82 · Accepted solution]

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

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

HTH

[zulfikar_syed]

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.

[zulfikar_syed]

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)