Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two list boxes with the same dimension. When I make a selection in the first list box, I do not want that same value available for selection in the second list box. How can I do this?
Try this:
=Aggr(If(GetSelectedCount(ProductName, False(),'Group1') = 0, ProductName, Only({1<ProductName = e({Group1} ProductName)>} ProductName)), ProductName)
Try this
List Box 1
FieldName
List Box 2
Aggr(Only({1<FieldName = p(FieldName)>}FieldName), FieldName)
That doesn't seem to work right for me. In the above example, I chose AAA Running Shoe. I do not want to be able to select the same value in the second list box.
Is this not working?
Aggr(Only({1<ProductName = e(ProductName)>}ProductName), ProductName)
Apologizes, so are you using two states for this?
Yes, I apologize for not making that clear. I called them Group1 and Group2. I just don't want to be able to compare the same product to each other in the chart.
I have not tested this, but try this
ProductName -> Group1
Aggr(Only({1<ProductName = e({Group1} ProductName)>} ProductName), ProductName) -> Group2
It somewhat works. The second list box starts out without any values and somehow when nothing is selected in the second list box, I still get some dollar values in the chart.
Try this:
=Aggr(If(GetSelectedCount(ProductName, False(),'Group1') = 0, ProductName, Only({1<ProductName = e({Group1} ProductName)>} ProductName)), ProductName)
Yeah, that seems to work! Can you explain what the expression is doing exactly?
When nothing is selected then show ProductName
=Aggr(If(GetSelectedCount(ProductName, False(),'Group1') = 0, ProductName, Only({1<ProductName = e({Group1} ProductName)>} ProductName)), ProductName)
When a ProductName is selected in Group1, then exclude whatever is selected in Group1's productname field
=Aggr(If(GetSelectedCount(ProductName, False(),'Group1') = 0, ProductName, Only({1<ProductName = e({Group1} ProductName)>} ProductName)), ProductName)