topic Get Selected Count in QlikView https://community.qlik.com/t5/QlikView/Get-Selected-Count/m-p/100472#M16016 <HTML><HEAD></HEAD><BODY><P>I have the following data in my data model.</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/208171_Capture.JPG" style="height: auto;" /></P><P></P><P>A resource works for 40 hours in a week. My requirement is that when user selects <EM>n</EM> number of projects, then the corresponding projectedhours should be substracted from 40.</P><P></P><P>Ex: If user selects 2 ptA projects and 3 ptB projects then (2x2.5hrs)+(3*4hrs) should be subtracted from 40 and I should get 40-12=27.</P><P></P><P>If user selects 1ptA project and 2 ptC projects then (1x2.5hrs)+(2x3hrs) should be subtracted from 40 and I should get 40-8.5=41.5.</P><P></P><P>I hope I have made the requirement clear. I'm not able to use the projectedhours in the expression.</P><P></P><P>Thanks,</P><P>Yash</P></BODY></HTML> Wed, 18 Jul 2018 10:33:52 GMT yashcena 2018-07-18T10:33:52Z Get Selected Count https://community.qlik.com/t5/QlikView/Get-Selected-Count/m-p/100472#M16016 <HTML><HEAD></HEAD><BODY><P>I have the following data in my data model.</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/208171_Capture.JPG" style="height: auto;" /></P><P></P><P>A resource works for 40 hours in a week. My requirement is that when user selects <EM>n</EM> number of projects, then the corresponding projectedhours should be substracted from 40.</P><P></P><P>Ex: If user selects 2 ptA projects and 3 ptB projects then (2x2.5hrs)+(3*4hrs) should be subtracted from 40 and I should get 40-12=27.</P><P></P><P>If user selects 1ptA project and 2 ptC projects then (1x2.5hrs)+(2x3hrs) should be subtracted from 40 and I should get 40-8.5=41.5.</P><P></P><P>I hope I have made the requirement clear. I'm not able to use the projectedhours in the expression.</P><P></P><P>Thanks,</P><P>Yash</P></BODY></HTML> Wed, 18 Jul 2018 10:33:52 GMT https://community.qlik.com/t5/QlikView/Get-Selected-Count/m-p/100472#M16016 yashcena 2018-07-18T10:33:52Z Re: Get Selected Count https://community.qlik.com/t5/QlikView/Get-Selected-Count/m-p/100473#M16017 <HTML><HEAD></HEAD><BODY><P>Is this not working</P><P></P><P><STRONG>40 - Sum(ProjectHours)</STRONG></P><P></P><P>EDIT: Why are you not able to use ProjectHours in your expression?<STRONG><BR /></STRONG></P></BODY></HTML> Wed, 18 Jul 2018 10:38:22 GMT https://community.qlik.com/t5/QlikView/Get-Selected-Count/m-p/100473#M16017 sunny_talwar 2018-07-18T10:38:22Z