Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
musketeers
Creator
Creator

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

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.

Labels (2)
1 Reply
theoat
Partner - Creator III
Partner - Creator III


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.