Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Preventing Drill Through - Unless Chart is Clicked

Hi All

I have a chart that uses a group as a dimension ( Year / Month / Day )

When clicking the chart it drills down into the relevant time period perfectly.

However if I select an item from one of the various list boxes to narrow the dataset depending on the dates of the narrowed dataset, the chart automatically changes timeframe.

Is it possible to prevent this and only have the drill through work when the chart is clicked?

Thanks

JP

1 Solution

Accepted Solutions
whiteline
Master II
Master II

Hi.

It's possible.

You have to add at least one null() value in Year dimension, it prevents QV from jumping in.

Similar thread:

http://community.qlik.com/message/277492#277492

View solution in original post

4 Replies
Gysbert_Wassenaar

You can use set expressions to disregard selections of your choice. Or you could detach the chart so it disregards any and all selections.


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert

I had not thought of expressions, that will work, although I would prefer not to ignore any of th selections I just don't want to have the timeframe update.

I solved it in a different way (although not totally satisfactory), I just removed the group as a the dimension and simply made it the year.

Thanks

JP

whiteline
Master II
Master II

Hi.

It's possible.

You have to add at least one null() value in Year dimension, it prevents QV from jumping in.

Similar thread:

http://community.qlik.com/message/277492#277492

Not applicable
Author

Thanks that is very useful and will solve the issue.

Regards

JP