topic Set Analysis problem in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/679290#M1084238 <HTML><HEAD></HEAD><BODY><P>I have three dimensions</P><P>marksobtained</P><P>Minmarks</P><P>%Studentid</P><P></P><P>expression: count({&lt;MarkObtain&lt;&lt;@ExamWiseModuleMinMark&gt;} distinct(#StudentMasterStudentID))&nbsp; </P><P></P><P><STRONG style="font-size: 12pt;">How to put MarkObtain&lt;&lt;@ExamWiseModuleMinMark in set analysis</STRONG></P></BODY></HTML> Mon, 30 Jun 2014 12:50:15 GMT 2014-06-30T12:50:15Z Set Analysis problem https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/679290#M1084238 <HTML><HEAD></HEAD><BODY><P>I have three dimensions</P><P>marksobtained</P><P>Minmarks</P><P>%Studentid</P><P></P><P>expression: count({&lt;MarkObtain&lt;&lt;@ExamWiseModuleMinMark&gt;} distinct(#StudentMasterStudentID))&nbsp; </P><P></P><P><STRONG style="font-size: 12pt;">How to put MarkObtain&lt;&lt;@ExamWiseModuleMinMark in set analysis</STRONG></P></BODY></HTML> Mon, 30 Jun 2014 12:50:15 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/679290#M1084238 2014-06-30T12:50:15Z Re: Set Analysis problem https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/679291#M1084239 <HTML><HEAD></HEAD><BODY><P>You can try to write like</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">count(</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">distinct</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> {$&lt;MarkObtain = {'&lt;$(=Min(ExamWiseModuleMark) ) '} &gt;} (#StudentMasterStudentID)) </SPAN></P></BODY></HTML> Mon, 30 Jun 2014 12:57:33 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/679291#M1084239 its_anandrjs 2014-06-30T12:57:33Z Re: Set Analysis problem https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/679292#M1084240 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try some thing llike this</P><P><STRONG>Count( Distinct {&lt;MarkObtain={"&lt;(=ExamWiseModuleMinMark)"}&gt;}StudentMasterStudentID)</STRONG></P></BODY></HTML> Mon, 30 Jun 2014 13:02:52 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/679292#M1084240 sasikanth 2014-06-30T13:02:52Z Re: Set Analysis problem https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/679293#M1084241 <HTML><HEAD></HEAD><BODY><P>wouldn't it take <STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f6f6f6;">ExamWiseModuleMinMark</STRONG> as a value , rather than a dimension </P></BODY></HTML> Mon, 30 Jun 2014 13:33:35 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/679293#M1084241 2014-06-30T13:33:35Z Re: Set Analysis problem https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/679294#M1084242 <HTML><HEAD></HEAD><BODY><P><BR />if<STRONG style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f6f6f6;">&nbsp; ExamWiseModuleMinMark is&nbsp; </STRONG></P><P>also a diemension</P><P>then use like Min(ExamWiseModuleMinMark)</P></BODY></HTML> Mon, 30 Jun 2014 13:42:10 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/679294#M1084242 sasikanth 2014-06-30T13:42:10Z