Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikie1
Contributor II
Contributor II

Set Analysis

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?

13 Replies
francisco_orte
Partner
Partner

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
Partner
Partner

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
Partner
Partner

Hi @francisco_orte 

Thanks for your advise and the links.

Learning is a continuous process for me.

Regards

qlikie1
Contributor II
Contributor II
Author

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