Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I have set analysis within a chart that has below syntax:
count(distinct {
<Primary_Product_Flag={1},
Target_Product=,Sales={"=sum(Sales)>0"},
Product_Code={"=sum({<Product_Group={'PS0016'},Key_IOL_Name >}Sales)>0"}
>
}
Product_Code)
Could you please help me to understand what Key_IOL_Name do at this point?
Hi @NageshSG
I highly recommend you to review again all documentation related to set analysis
May be your expressions works as you are explaining, but it's a different expression, with different results of that proposed by @qlikie1
In our first scenario, we only intend to avoid selections on Key_IOL_Name
Hope it helps
Regards
Hi @qlikie1
Just try to add Target_Product= on the set analysis you are using for Product_Code. In that case Target_Product selections will not affect to Product_Code.
Hope it helps
Regards
Thanks for your advise and the links.
Learning is a continuous process for me.
Regards
@francisco_orte Thank you very much for prompt support and detailed explanations! You helped me a lot!