Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Clicking of a graph affects another graph

Hi All,

  Can anyone help me sort this issue pls. I have had this issue but tried the same thing i did then to resolve the issue, but it still persists. I have to two line graphs on a sheet, when i click a button on one of the graph and a click a button on  the other graph, it influences and inflates the figures on the first clicked graph. Please help!! sunnystalwar1‌ @omar ben Salem

1 Solution

Accepted Solutions
sunny_talwar

I think the issue is not the data... it is the sorting which changed because you used this expression

match([RESOLVE_TIME],'May-16','Jun-16','Jul-16','Aug-16','Sep-16','Oct-16','Nov-16','Dec-16','Jan-17','Feb-17','Mar-17','Apr-17','May-17','Jun-17')

try to change it to this

match(Only({1}[RESOLVE_TIME]),'May-16','Jun-16','Jul-16','Aug-16','Sep-16','Oct-16','Nov-16','Dec-16','Jan-17','Feb-17','Mar-17','Apr-17','May-17','Jun-17')

View solution in original post

9 Replies
Not applicable
Author

sunny_talwar

Would you be able to share your app to show the issue?

OmarBenSalem

The button in the second chart is a dimension; suppose it's Month field dimension.

To prevent it from affecting the first chart; add to your measure (of the first chart) Month=

exp:

sum({<Month=>}sales)

Not applicable
Author

Please find the attached. Its the "Life science cloud Dashboard" sheet. Thanks

Not applicable
Author

Hi Omar,

  Thanks for replying. Tried it but still not working.

Not applicable
Author

You can find the app attached above, Thanks

sunny_talwar

I think the issue is not the data... it is the sorting which changed because you used this expression

match([RESOLVE_TIME],'May-16','Jun-16','Jul-16','Aug-16','Sep-16','Oct-16','Nov-16','Dec-16','Jan-17','Feb-17','Mar-17','Apr-17','May-17','Jun-17')

try to change it to this

match(Only({1}[RESOLVE_TIME]),'May-16','Jun-16','Jul-16','Aug-16','Sep-16','Oct-16','Nov-16','Dec-16','Jan-17','Feb-17','Mar-17','Apr-17','May-17','Jun-17')

Not applicable
Author

Genius you are!!!. What does the ONLY function do pls??

sunny_talwar

Its not the Only which did the trick, its actually the set analysis {1} which ignore any or all selections. The reason I had to use Only was because I cannot use set analysis without some kind of aggregation....