I need help with conditional enabling of the text box.
Count and YEAR as default selection on open.
I should not be able to select Total Policies or STATUS , when YEAR and Count are selected. If I select any of these two fields , I should get the error message in the place of table .
Similarly, if I select STATUS and Total Policies, I should not be able to select YEAR and Count fields. If I select, I should get the error message.
QTR can be selected in any of the scenario.
Condition needed is:
The error message text box should enable only when wrong selections made and not always. Please help with conditional enabling of the text box.
I think it may be easier to define Field event triggers on _DIM that clear possible selections 'Total Policies' and 'STATUS' selections whenever 'YEAR' or 'Count' are selected, and vice-versa. The number of possible combinations in your solution may cause you to create unmanageable IF() calls...
You should not be able to select Total Policies or STATUS , when YEAR and Count are selected.
if it is true then what basis you will select the Total Policies or STATUS? and why u required error message because ur requirement is u should not be able to select the Total Policies or STATUS?
Scenerio2:
You should not be able to select YEAR and Count , when Total Policies and STATUS are selected
same comments vice verse.
Please find the attached application.
What I have done,
You will not be able to select Total Policies or STATUS , when YEAR and Count are selected and vice versa.
Hi Peter, as you said, its has become too confusing and complicated for making selections. I made two tabs, one for 'YEAR and Count' and the other for 'STATUS and Total Policies' so that there is no choice of selections . QTR is available in both tabs.
Also, it would be great if you can please make the changes as per your option of'clear possible selections' to the qvw I have attached to my original post. It would be helpful for me to learn.
