topic Re: Preventing Drill Through - Unless Chart is Clicked in QlikView

Preventing Drill Through - Unless Chart is Clicked

Wed, 07 Nov 2012 15:50:16 GMT

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

Re: Preventing Drill Through - Unless Chart is Clicked

Gysbert_Wassenaar — Wed, 07 Nov 2012 15:54:06 GMT

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

Re: Preventing Drill Through - Unless Chart is Clicked

Wed, 07 Nov 2012 16:18:39 GMT

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

Re: Preventing Drill Through - Unless Chart is Clicked

whiteline — Wed, 07 Nov 2012 19:32:04 GMT

Hi.

It's possible.

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

Re: Preventing Drill Through - Unless Chart is Clicked

Sun, 11 Nov 2012 19:03:59 GMT

Thanks that is very useful and will solve the issue.

Regards