topic Re: help in set analysis in QlikView https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/734424#M262960 <HTML><HEAD></HEAD><BODY><P>what shall I do to make it display only S1, and S2 regardless of any selection made</P></BODY></HTML> Tue, 08 Jul 2014 14:55:07 GMT ali_hijazi 2014-07-08T14:55:07Z help in set analysis https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/734422#M262958 <HTML><HEAD></HEAD><BODY><P>got the following expression</P><P></P><P><BR /> </P><P><BR />count</P><P>(<BR /> {</P><P></P><P>&lt;</P><P></P><P><SPAN style="color: #800000;">UNIQUENESS</SPAN>={1}</P><P></P><P>,<SPAN style="color: #800000;">BACKPORTED_FLAG</SPAN>={'Y'}</P><P></P><P>,<SPAN style="color: #800000;">H_Product_Type</SPAN>={'MX3'}</P><P></P><P>,<SPAN style="color: #800000;">DEFECT_SEVERITY_ID</SPAN>={'S1','S2'}</P><P></P><P></P><P></P><P></P><P></P><P>&gt;</P><P></P><P>} <SPAN style="color: #800000;">MR_KEY_VERS_DEF_ID</SPAN>)</P><P></P><P>+</P><P></P><P><SPAN style="color: #0000ff;">SUM</SPAN>({$} <SPAN style="color: #0000ff;">IF</SPAN>(<SPAN style="color: #800000;">DEFECT_DETECTION_PHASE</SPAN>='PRE_RELEASE',<SPAN style="color: #0000ff;">AGGR</SPAN>(<SPAN style="color: #0000ff;">COUNT</SPAN>({</P><P></P><P>&lt;</P><P></P><P><SPAN style="color: #800000;">UNIQUENESS</SPAN>={1}</P><P></P><P>,<SPAN style="color: #800000;">BACKPORTED_FLAG</SPAN>={'Y'}</P><P></P><P>,<SPAN style="color: #800000;">H_Product_Type</SPAN>={'MX3'}</P><P></P><P>,<SPAN style="color: #800000;">DEFECT_SEVERITY_ID</SPAN>={'S1','S2'}</P><P></P><P>,<SPAN style="color: #800000;">DEFECT_DETECTION_PHASE</SPAN>={'POST_RELEASE'}</P><P></P><P></P><P></P><P></P><P></P><P>&gt;</P><P></P><P></P><P></P><P>} <SPAN style="color: #800000;">MR_KEY_VERS_DEF_ID</SPAN>),<SPAN style="color: #800000;">FIX_PERIOD</SPAN>, <SPAN style="color: #800000;">RELEASE</SPAN>),0))</P><P></P><P></P><P></P><P>why would the second part be affected by the selection of a severity value S1, and S2</P><P>please advise</P></BODY></HTML> Tue, 08 Jul 2014 14:45:55 GMT https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/734422#M262958 ali_hijazi 2014-07-08T14:45:55Z Re: help in set analysis https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/734423#M262959 <HTML><HEAD></HEAD><BODY><P>Because you are counting with the condition <SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">DEFECT_SEVERITY_ID</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">={'S1','S2'}</SPAN> that is all the records includint these 2 values. If you select only S1 for example then you will restrict the result.</P></BODY></HTML> Tue, 08 Jul 2014 14:51:20 GMT https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/734423#M262959 alexandros17 2014-07-08T14:51:20Z Re: help in set analysis https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/734424#M262960 <HTML><HEAD></HEAD><BODY><P>what shall I do to make it display only S1, and S2 regardless of any selection made</P></BODY></HTML> Tue, 08 Jul 2014 14:55:07 GMT https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/734424#M262960 ali_hijazi 2014-07-08T14:55:07Z Re: help in set analysis https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/734425#M262961 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>...</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">+</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #0000ff;">SUM</SPAN>({$} <SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #0000ff;">IF</SPAN>(<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">DEFECT_DETECTION_PHASE</SPAN>='PRE_RELEASE' and (<SPAN style="font-family: inherit; font-style: inherit; font-weight: inherit; color: #800000;">DEFECT_SEVERITY_ID</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">='S1' or <SPAN style="font-family: inherit; font-style: inherit; font-weight: inherit; color: #800000;">DEFECT_SEVERITY_ID</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">='S2' </SPAN>)</SPAN>,<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #0000ff;">AGGR</SPAN>(<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #0000ff;">COUNT</SPAN>({</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&lt;</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">UNIQUENESS</SPAN>={1}</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">,<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">BACKPORTED_FLAG</SPAN>={'Y'}</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">,<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">H_Product_Type</SPAN>={'MX3'}</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">,<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">DEFECT_SEVERITY_ID</SPAN>=</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">,<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">DEFECT_DETECTION_PHASE</SPAN>={'POST_RELEASE'}</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; </P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&gt;</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">...</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Let me know</P></BODY></HTML> Tue, 08 Jul 2014 14:57:48 GMT https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/734425#M262961 alexandros17 2014-07-08T14:57:48Z Re: help in set analysis https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/734426#M262962 <HTML><HEAD></HEAD><BODY><P>no i tried this already it gives wrong results</P></BODY></HTML> Tue, 08 Jul 2014 14:59:16 GMT https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/734426#M262962 ali_hijazi 2014-07-08T14:59:16Z Re: help in set analysis https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/734427#M262963 <HTML><HEAD></HEAD><BODY><P>look can you help me in the disucussion titled help in expression</P><P>let's ignore this part</P></BODY></HTML> Tue, 08 Jul 2014 15:00:07 GMT https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/734427#M262963 ali_hijazi 2014-07-08T15:00:07Z