How to get excluded <Gray Values which are not related> values separated by comma of a field when we select value in other field ?

[Anonymous]

In attached QVW if I select the value in storeid field the text box with concat function < concat({1-$}DISTINCT Storeid,',')  it works well as it gives me the gray out values in storeid with respect to the selection in storeid but If select any value in Prodid field then the text box gives me all values of storeid separated by comma. How can I get only gray out values of storeid separated by comma with respect to the value selected in prodid ?

[sunny_talwar]

I think the attached qvw is empty, can you reattach the qvw with data in it

[Anonymous]

Attached.

[sunny_talwar · Accepted solution]

Try this:

=Concat({1<Storeid = e(Storeid)>} DISTINCT Storeid, ',')

[Anonymous]

Thank you so much Sunny. It does work.

[yamini_sarraf]

Hi Sunny ,

I tried using above expression in listbox sort property but didn't get expected result.

I have a requirement that current selected value should be on top and below all excluded values are in sorted order with some key column.

I am using this expression :

aggr(only({<Field_1= e(Field_1)>}Field_1),Key_column1,Key_column2)

Do you have any suggestion ?

Thanks,

Yamini

[sunny_talwar]

Would you be able to share a sample to show what you have right now?