Display the only matched values in the chart disregarding the selection

[rabbani_sk]

HI All,

I have a requirement need to display the report only for matched values between the tables disregarding the selections,

I have below Tables with join key ID

Table 1:

ID	Value1
1	w1
2	w2
3	w3
4	w4
5	w5

Table2:

ID	Value2
1	w1
2	w1
3	w1
4	w1
5	w1

If i consider a bar chart with dimension as "ID" and expression as Count({$<Value1>}Value2) .

Take Value1 in a list box, and do some selections w1,w2,w3,w4,w5 seperately then the chart is giving count of 5 in the chart.

Expected Result:

In the chart i am getting all data for all value selections w1,w2,w3,w4,w5.

Actually expected result is, It shud not display all data in the chart for  the values w2,w3,w4,w5 it only need to dispaly all data for the selection w1.

Is there any way to do it ?

Thanks in advance

Please find the attached sample .qvw file

[Gysbert_Wassenaar · Accepted solution]

Try this expression in your bar chart: =count({$<Value1,Value2={'$(=only(Value1))'}>}Value2)

[rabbani_sk]

Thanks alot Gilbert Wassenaar it is perfectly working as expected

[Anonymous]

Hi Rabbani,

I'm glad to see your issue is resolved. Please take a moment to Mark Replies as Correct or Helpful.

Thank you,

Qlik Community Team

[Gysbert_Wassenaar]

You're welcome Robin