Need help with set analysis expression

[#1]

Dear all,

I really need help with this expresion. I have attached an example qvw. What I need to do is to show the colors of the first series for each product. First series is th eminimum series and can change depending on the selection (for example if you select special colors).

I tried to use set anylsis for that

concat( distinct {< Product_series ={$(=min(Product_series))}> } Product_color, ', ')

but it gives me correct values only if one product is selected. If I do not select a product it searches for the minumum of product series and doesn't pay attention to my dimension (product id). I need it to work for each product id though..

As you see in the screenshot below I dont get light blue color for my first series of the 4087 product. Thats because my set expression looks for series 1.

As soon as I filter for one product 4087, I get the correct value, beacues my set expresion gives me 4 as the minimum series.

I think I am missing something in the expression but can't find the solution.

Does anyone have an idea how to make it work? I would really appreciate your help.

Best regards,

Marina

[sunny_talwar · Accepted solution]

Set analysis is evaluated once per chart, try using Aggr() function here:

Concat(Aggr(If(Product_series = Min(TOTAL <Product_id> Product_series), Product_color), Product_id, Product_series, Product_color), ', ')

[#3]

Exactly what I needed, thank you so much!