function to return only green color values in list box and not all

[musketeers]

Hi, I have a scenario where there are multiple products. Let say P1, P2, P3 and so on. It is shown in filter pane chart object. One another field say Commodity. A product can have muiltiple commodities. So P1 can have C1, C2, C3 and so on. Few commodities are unique to that product. So they can be related to only one product.

If I have selected all products and selected a unique commodity which is related to product P1.

So in Filterpane of Product , we can see that only P1 is in green color but since we have selected all products, remaining are in Grey color with Tick mark.

The function GetFieldSelection returns all the seleted values. Is there any way to return only the green color value. In this scenario I want to only P1 in my calculation.

[theoat]

ProductP for P1, P2, P3...
ProductC for C1, C2, C3...
Try this :
{$
<ProductC = P({<ProductP ={"$(=GetFieldSelections(ProductP ,'","'))"}>} ProductC )>
}
concat(ProductP ,',')

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.