Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this expression in your bar chart: =count({$<Value1,Value2={'$(=only(Value1))'}>}Value2)
Try this expression in your bar chart: =count({$<Value1,Value2={'$(=only(Value1))'}>}Value2)
Thanks alot Gilbert Wassenaar it is perfectly working as expected
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
You're welcome Robin