Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi.
It's possible.
You have to add at least one null() value in Year dimension, it prevents QV from jumping in.
Similar thread:
You can use set expressions to disregard selections of your choice. Or you could detach the chart so it disregards any and all selections.
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
Hi.
It's possible.
You have to add at least one null() value in Year dimension, it prevents QV from jumping in.
Similar thread:
Thanks that is very useful and will solve the issue.
Regards
JP