topic Re: Set Analysis function for Category Sales when Product is selected in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-function-for-Category-Sales-when-Product-is/m-p/1439885#M459493 <HTML><HEAD></HEAD><BODY><P>Can you give screenshot of your data model?</P></BODY></HTML> Tue, 19 Sep 2017 08:31:13 GMT shraddha_g 2017-09-19T08:31:13Z Set Analysis function for Category Sales when Product is selected https://community.qlik.com/t5/QlikView/Set-Analysis-function-for-Category-Sales-when-Product-is/m-p/1439884#M459492 <HTML><HEAD></HEAD><BODY><P>I have the below Product Master Table in my app:</P><P></P><P>PRODUCT_KEY</P><P>PRODUCT</P><P>..</P><P>..</P><P>CATEGORY_KEY</P><P>CATEGORY</P><P>..</P><P></P><P></P><P>I have a requirement to design a table for product sales. The below is the table Attributes required:</P><P></P><P>PRODUCT</P><P>PRODUCT SALES VALUE</P><P>CATEGORY SALES VALUE</P><P></P><P>Here the category Sales Value is the total sales for the specific category to which the product belongs to. </P><P></P><P>I know this can be done by Set Analysis. Someone can guide me please?</P></BODY></HTML> Tue, 19 Sep 2017 08:27:44 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-function-for-Category-Sales-when-Product-is/m-p/1439884#M459492 madnanansari 2017-09-19T08:27:44Z Re: Set Analysis function for Category Sales when Product is selected https://community.qlik.com/t5/QlikView/Set-Analysis-function-for-Category-Sales-when-Product-is/m-p/1439885#M459493 <HTML><HEAD></HEAD><BODY><P>Can you give screenshot of your data model?</P></BODY></HTML> Tue, 19 Sep 2017 08:31:13 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-function-for-Category-Sales-when-Product-is/m-p/1439885#M459493 shraddha_g 2017-09-19T08:31:13Z Re: Set Analysis function for Category Sales when Product is selected https://community.qlik.com/t5/QlikView/Set-Analysis-function-for-Category-Sales-when-Product-is/m-p/1439886#M459494 <HTML><HEAD></HEAD><BODY><P>My data model is very detailed. I cannot share as is. </P><P></P><P>pls. take any simplest standard sample with PRODUCT dimension or any other and SALES fact. </P></BODY></HTML> Tue, 19 Sep 2017 10:08:28 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-function-for-Category-Sales-when-Product-is/m-p/1439886#M459494 madnanansari 2017-09-19T10:08:28Z