Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zulfikar_syed
New Contributor

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
kkkumar82
Valued Contributor III

Re: Un-associated fields

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

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

HTH

5 Replies
zulfikar_syed
New Contributor

Re: Un-associated fields

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

Chart function solution is highly appreciated

ChennaiahNallani
Contributor III

Re: Un-associated fields

Share sample data and app

kkkumar82
Valued Contributor III

Re: Un-associated fields

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

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

HTH

zulfikar_syed
New Contributor

Re: Un-associated fields

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
New Contributor

Re: Un-associated fields

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)