Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zulfikar_syed
Contributor II
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
kkkumar82
Specialist III
Specialist III

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

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

HTH

View solution in original post

5 Replies
zulfikar_syed
Contributor II
Contributor II
Author

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

Chart function solution is highly appreciated

ChennaiahNallani
Creator III
Creator III

Share sample data and app

kkkumar82
Specialist III
Specialist III

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

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

HTH

View solution in original post

zulfikar_syed
Contributor II
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.

zulfikar_syed
Contributor II
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)