Set Analysis

[qlikie1]

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?

[francisco_orte]

Hi @NageshSG 

I highly recommend you to review again all documentation related to set analysis

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se...

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

[francisco_orte]

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

[NageshSG]

Hi @francisco_orte 

Thanks for your advise and the links.

Learning is a continuous process for me.

Regards

[qlikie1]

@francisco_orte  Thank you very much for prompt support and detailed explanations! You helped me a lot!