Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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

Re: Clicking of a graph affects another graph

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

Re: Clicking of a graph affects another graph

Re: Clicking of a graph affects another graph

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

Partner
Partner

Re: Clicking of a graph affects another graph

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

Re: Clicking of a graph affects another graph

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

Not applicable

Re: Clicking of a graph affects another graph

Hi Omar,

  Thanks for replying. Tried it but still not working.

Not applicable

Re: Clicking of a graph affects another graph

You can find the app attached above, Thanks

Re: Clicking of a graph affects another graph

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

Not applicable

Re: Clicking of a graph affects another graph

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

Re: Clicking of a graph affects another graph

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....