topic Expression in QlikView https://community.qlik.com/t5/QlikView/Expression/m-p/986871#M948010 <HTML><HEAD></HEAD><BODY><P>=if([BranchID]= '1',count(PatientID),count(PatientID where Branch ID = '1')</P><P>or</P><P>=Count (PatientID) where BranchID = '1'</P><P></P><P>How can I write this expression with a correct way ?!</P><P></P><P></P><P>Regards</P></BODY></HTML> Sun, 27 Dec 2015 05:59:54 GMT Anonymous 2015-12-27T05:59:54Z Expression https://community.qlik.com/t5/QlikView/Expression/m-p/986871#M948010 <HTML><HEAD></HEAD><BODY><P>=if([BranchID]= '1',count(PatientID),count(PatientID where Branch ID = '1')</P><P>or</P><P>=Count (PatientID) where BranchID = '1'</P><P></P><P>How can I write this expression with a correct way ?!</P><P></P><P></P><P>Regards</P></BODY></HTML> Sun, 27 Dec 2015 05:59:54 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/986871#M948010 Anonymous 2015-12-27T05:59:54Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/986872#M948012 <HTML><HEAD></HEAD><BODY><P>count({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[BranchID]={ '1'}</SPAN>&gt;}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">PatientID</SPAN>)</P><P></P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: 'comic sans ms', sans-serif;">Feeling Qlikngry?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="8342" data-objecttype="102" href="https://community.qlik.com/docs/DOC-8342" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">How To /Missing Manual(25 articles)</A></P></BODY></HTML> Sun, 27 Dec 2015 06:06:27 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/986872#M948012 robert_mika 2015-12-27T06:06:27Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/986873#M948013 <HTML><HEAD></HEAD><BODY><P>=count(if(BranchID='1',BranchID))</P></BODY></HTML> Sun, 27 Dec 2015 07:06:52 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/986873#M948013 Kushal_Chawda 2015-12-27T07:06:52Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/986874#M948015 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14512040524099639" jivemacro_uid="_14512040524099639"> <P>=Aggr(If(BranchID=1,Count(Patient)),BranchID)</P> </PRE><P></P><P></P><P>PFA,</P><P>Hope this Helps,</P><P>Regards,</P><P>Hirish</P></BODY></HTML> Sun, 27 Dec 2015 08:14:42 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/986874#M948015 HirisH_V7 2015-12-27T08:14:42Z