Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I was wondering if there is any way to set a dimension in a Table Chart as unselectable to a user. For example, if I had an Area dimension that had the values North, South, West and East in it, usually if a user clicks on North, the chart will refresh with only data that is associated with the North area. Is there any way to disable this functionality so that when the user clicks on the Area nothing happens?
Any information would be grealy appreciated!
Hi:
Unfortunately, sometimes we can't do what we have on mind. It's very difficult to filter and not to filter at the same time. I've just made an example of what IsrarKhan have said. It does not work. It does not filter by any dimension. I saw it as the correct answer but it is not.
Good luck.
How about a trigger that clears the selection on this dimension?
It just means that in the entire application you can't do any selections on that dimension.
may be you can use the lock field option in document properties.
This is for the entire application or just for an especific chart?
If it is for the entire application, you can put an action in the Area field that everytime you select Area, it will clear the field Area. So, anytime you try to select an Area it will clear the area selection.
To do this you go:
Settings>>Document Properties >> Triggers >> On Field Event Triggers, you may Add Action(s) On Select in the field you want to disable >> Add >> Selection >> Clear Field >> OK >> Put in the Field box, the name of the field you want to clear, in this case, Area.
I hope it helps.
I think you are fighting against the fundamental behaviour of the table chart.
PFA
David,
I agree with you 100% percent. Unfortunately the customer doesn't see it that way.