Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can we restrict only one value to be selected from the listbox .....????
yes in list box select one value
and go to general in charts properties-> select always one select value
hope this helps
Hi,
You can do this by
1. Select single value in the List box.
2. Select Properties -> General -> Always One Selected value option
Hope this helps you.
Regards,
Jagan.
But the problem with this is that you can never clear the field. /Marcus
Hello There,
I am also having same problem, but in my case "Always One Selected value option" is in Disable. How can I enable this?
Best,
Siva.
Siva,
This option is only available after you selected exactely one single value.
Hi Marcus,
I had created a video post on how to clear "Always One Selected Value". Please check this video post :
Cheers,
DV
Hi Siva,
Please check attached file. Hope this is what you are expecting.
Regards,
Jagan.
Hi All,
Jagan's solution should suffice. However, I try to avoid using triggers as much as possible. So if you wanted to acheive the same functionality then you use this expression :
=IF(GetSelectedCount(Year) = 0, Year, Aggr(MAX({<Year ={$(=FirstSortedValue( Year, -Year))}>} Year), Year))
Ofcourse, you can change the logic to select appropriate Year when the user selects multiple values. In this example, I'm using the max Year.
I hope this makes sense.
Good luck!
Cheers,
DV
DV,
I think your solution using an expression in the list box is not showing the same functionality, since it's only limiting the values shown in this single list box. If you select more than one value, these values will actually be selected (and affect other objects / results). And I believe you can't change this behaviour just by using a list box expression field.
Regards,
Stefan