Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a filter, where the options are A and B.
The Current Selection Box is displaying the value, even after clicking the Clear Selection option.
By default, it is displaying either A or B.
Can anyone help me with this?
Thanks,
Praveen
Message was edited by: Praveen Kumar Updated
Hi Tresesco,
EXp1_tres2.qvw is fine. But my requirement is bit different.
I dont need that "Always One selected value" to be unchecked.
I need it, because,
1. I need only one filter value to be selected once (No multiselect), thats why we have enabled it.
the file which I sent is as per my requirement.
The problem is,
The current selection is showing the value. even if we clear it.
Hi All,
Sorry.
Please find the updated file.
I dont need that "Always One selected value" to be unchecked.
I need it, because,
1. I need only one filter value to be selected once (No multiselect), thats why we have enabled it.
the file which I sent is as per my requirement.
The problem is,
The current selection is showing the value. even if we clear it.
The current selection box will show whatever field selected. I'm not sure if the default behavior can be altered but I think we can manipulate it. In the Current Selection box properties you can change the text color so that it will match with the back ground whenever getselectedcount(yourfield)>0 this will hide the text but other columns like the "Status" and "clear Icon" will remain visible unless you remove that from the Current Selection Box properties.
Or you can have a thin textbox with layer top than the current selection box for the particular field which has one selected value.
This will make my font colorless even on selecting.
The problem is. I havent selected any filter here. But since I am using INLINE function for creating this List Box filter, By default, any of the one value is always selected.
I really dont know how to chage it.
If you see the Edit Script page, You can find my Inline function script.
The reason why I used inline funtion is, I need two column header names as a filter values.
Are you looking something that allows user to select 'ONLY one' value from the list and be able to clear as well?
Hi Tresesco,
Please see the document which I have shared yesterday. the Updated one.
That is meeting all my requirements. That is how I need the selections and display.
I am facing only one problem. Clear selection Box is displaying the value, even after clicking the CLEAR button.
I guess, you got my problem ?
Thanks,
Praveen
Hi Praveen,
You just need to uncheck the "Always One Selected Value" in the List Box Properties under the General Tab.
BR,
dani
Please understand that, one field doesn't get cleared if 'Always One Selected Value' is enabled for it even if you press 'Clear All'. And if one field has got to remain selected, it will be shown in the current selection box. There is no way to not show in the current selection box as not/nothing selected for one field which is really selected by user.
Thanks Tresesco.
Try this:
1. Uncheck the "Always One Selected Value" option on the General tab.
2. Use a sheet trigger event on action "Select in Field" and give in or A or B to be selected when the sheet is activated.