topic Set analysis help! in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-help/m-p/180566#M46937 <HTML><HEAD></HEAD><BODY><DIV style="background-color: #ffffff; margin: 8px; font-family: Arial, Helvetica, sans-serif; color: #000000; font-size: 12px; background-origin: initial; background-clip: initial;"><P>Hi,</P><P>I am trying to work on a set analysis expression which is not giving me the desired results.</P><P>On the 'Non continuers' table/chart, I should get a results of 6 Non continuers, but my expression keeps giving me 5.</P><P>I basically need to show all students/student IDs where they studied in Year 09, AND don't continue in 2010(AcYr 201011).</P><P>So, it must distinct count the Stu_Prog where the studentID is in 2009, but not in 2010.</P><P>My continuers table/chart seems to be giving me the correct results.</P><P>I have attached the .qvw I am using.</P><P>Any help would be much appreciated!</P><P>Thanks.</P></DIV></BODY></HTML> Mon, 24 Jan 2011 05:00:30 GMT 2011-01-24T05:00:30Z Set analysis help! https://community.qlik.com/t5/QlikView/Set-analysis-help/m-p/180566#M46937 <HTML><HEAD></HEAD><BODY><DIV style="background-color: #ffffff; margin: 8px; font-family: Arial, Helvetica, sans-serif; color: #000000; font-size: 12px; background-origin: initial; background-clip: initial;"><P>Hi,</P><P>I am trying to work on a set analysis expression which is not giving me the desired results.</P><P>On the 'Non continuers' table/chart, I should get a results of 6 Non continuers, but my expression keeps giving me 5.</P><P>I basically need to show all students/student IDs where they studied in Year 09, AND don't continue in 2010(AcYr 201011).</P><P>So, it must distinct count the Stu_Prog where the studentID is in 2009, but not in 2010.</P><P>My continuers table/chart seems to be giving me the correct results.</P><P>I have attached the .qvw I am using.</P><P>Any help would be much appreciated!</P><P>Thanks.</P></DIV></BODY></HTML> Mon, 24 Jan 2011 05:00:30 GMT https://community.qlik.com/t5/QlikView/Set-analysis-help/m-p/180566#M46937 2011-01-24T05:00:30Z Set analysis help! https://community.qlik.com/t5/QlikView/Set-analysis-help/m-p/180567#M46938 <HTML><HEAD></HEAD><BODY><P>hei</P><P>attach is your example with the correct result</P><P>what i did is changing the set analsys a lttle</P><P>hhave a look inside the formula</P><P>hope its helps you</P><P></P></BODY></HTML> Mon, 24 Jan 2011 10:30:04 GMT https://community.qlik.com/t5/QlikView/Set-analysis-help/m-p/180567#M46938 lironbaram 2011-01-24T10:30:04Z