topic Re: Syntax in QlikView https://community.qlik.com/t5/QlikView/Syntax/m-p/788222#M278742 <HTML><HEAD></HEAD><BODY><P>tried that.. does not work</P></BODY></HTML> Wed, 11 Feb 2015 18:06:10 GMT naziralala 2015-02-11T18:06:10Z Syntax https://community.qlik.com/t5/QlikView/Syntax/m-p/788220#M278740 <HTML><HEAD></HEAD><BODY><P>Count({&lt;LastName = ('Smith'), HireDate&gt;= {‘1/1/2013’}&gt;} Distinct SalesPersonID)</P><P></P><P>What is the error?</P></BODY></HTML> Wed, 11 Feb 2015 17:15:26 GMT https://community.qlik.com/t5/QlikView/Syntax/m-p/788220#M278740 naziralala 2015-02-11T17:15:26Z Re: Syntax https://community.qlik.com/t5/QlikView/Syntax/m-p/788221#M278741 <HTML><HEAD></HEAD><BODY><P>need braces{} around Smith, not parentheses</P></BODY></HTML> Wed, 11 Feb 2015 18:01:04 GMT https://community.qlik.com/t5/QlikView/Syntax/m-p/788221#M278741 m_woolf 2015-02-11T18:01:04Z Re: Syntax https://community.qlik.com/t5/QlikView/Syntax/m-p/788222#M278742 <HTML><HEAD></HEAD><BODY><P>tried that.. does not work</P></BODY></HTML> Wed, 11 Feb 2015 18:06:10 GMT https://community.qlik.com/t5/QlikView/Syntax/m-p/788222#M278742 naziralala 2015-02-11T18:06:10Z Re: Syntax https://community.qlik.com/t5/QlikView/Syntax/m-p/788223#M278743 <HTML><HEAD></HEAD><BODY><P>are you getting an error or just not the results that you hoped for?</P></BODY></HTML> Wed, 11 Feb 2015 18:08:39 GMT https://community.qlik.com/t5/QlikView/Syntax/m-p/788223#M278743 m_woolf 2015-02-11T18:08:39Z Re: Syntax https://community.qlik.com/t5/QlikView/Syntax/m-p/788224#M278744 <HTML><HEAD></HEAD><BODY><P>It is showing as Error in modifier expression</P></BODY></HTML> Wed, 11 Feb 2015 18:26:33 GMT https://community.qlik.com/t5/QlikView/Syntax/m-p/788224#M278744 naziralala 2015-02-11T18:26:33Z Re: Syntax https://community.qlik.com/t5/QlikView/Syntax/m-p/788225#M278745 <HTML><HEAD></HEAD><BODY><P>The other thing that is wrong is the syntax for &gt;=</P><P>It needs to be something like this:</P><P>HireDate= {‘&gt;=1/1/2013’}</P><P></P><P>also set analysis is very picky about date formats. It might be better to use numbers for the comparison.</P></BODY></HTML> Wed, 11 Feb 2015 18:44:50 GMT https://community.qlik.com/t5/QlikView/Syntax/m-p/788225#M278745 m_woolf 2015-02-11T18:44:50Z Re: Syntax https://community.qlik.com/t5/QlikView/Syntax/m-p/788226#M278746 <HTML><HEAD></HEAD><BODY><P>This was helpful.</P><P></P><P>Thank You</P></BODY></HTML> Mon, 27 Apr 2015 15:50:05 GMT https://community.qlik.com/t5/QlikView/Syntax/m-p/788226#M278746 naziralala 2015-04-27T15:50:05Z Re: Syntax https://community.qlik.com/t5/QlikView/Syntax/m-p/788227#M278747 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Count({&lt;LastName = {'Smith'}, HireDate= {‘&gt;=1/1/2013’}&gt;} Distinct SalesPersonID)</SPAN></P></BODY></HTML> Mon, 27 Apr 2015 16:12:15 GMT https://community.qlik.com/t5/QlikView/Syntax/m-p/788227#M278747 ankitaag 2015-04-27T16:12:15Z Re: Syntax https://community.qlik.com/t5/QlikView/Syntax/m-p/788228#M278748 <HTML><HEAD></HEAD><BODY><P>Thanks Ankita,</P><P></P><P>this works...</P></BODY></HTML> Mon, 27 Apr 2015 20:32:07 GMT https://community.qlik.com/t5/QlikView/Syntax/m-p/788228#M278748 naziralala 2015-04-27T20:32:07Z Re: Syntax https://community.qlik.com/t5/QlikView/Syntax/m-p/788229#M278749 <HTML><HEAD></HEAD><BODY><P>Hi Nazira,</P><P></P><P>Kindly mark any 1 of the answer as helpful correct so as to close the discussion <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 28 Apr 2015 08:14:38 GMT https://community.qlik.com/t5/QlikView/Syntax/m-p/788229#M278749 ankitaag 2015-04-28T08:14:38Z