Conditional show hide values in list box

[musketeers]

Hi,

I have two list box.

In first list box I have IDs values 1, 2 and 3.

In second list box I am displaying the Product names.

If I select ID = 1 in first list box, I wand to display all product name except the product PRODUCT-1.

For the rest of the IDs in first list box, I need to display all product names in second list box.

to do this I have used if condition in second listbox, but it is not hiding, it is disabling the PRODUCT-1.

I have used Hide Exclude option also but it is not correct option in my case.

I just do not want to display PRODUCT-1 wher ID = 1 is selected in first list box.

Thanks

[jazzsran]

Hi Rajneesh,

Were you able to find the solution for this?

I have similar condition where the non related values should hide in the list box1 based on the selection in list box2, however later when selecting the values from the list box1, user should be able to see the non- selected options as well here, means it should show all the values according the list box2.

I was able to hide the values in the list box1 using the below expression but when i am selecting from the available values in the list box1 later, all the other values from list box1 are also disappearing except the selected one.

EXP: aggr(only({<Dimension= P(Dimension)>}Dimension),Dimension)

Can anyone help?

Thanks in advance