topic Re: Expression Syntax in QlikView https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/936676#M953820 <HTML><HEAD></HEAD><BODY><P>Not a problem. I am glad I have been helpful all day today <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 19 Nov 2015 00:55:38 GMT sunny_talwar 2015-11-19T00:55:38Z Expression Syntax https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/936673#M953817 <HTML><HEAD></HEAD><BODY><P>I am trying to limit my expression to a particular situation as follows:</P><P></P><P>&nbsp; <SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Courier New'; color: blue;">RangeSum</SPAN><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Courier New'; color: blue;">Above</SPAN><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Courier New'; color: blue;">total</SPAN> <SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Courier New'; color: blue;">Sum</SPAN><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Courier New'; color: maroon;">Amount</SPAN><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">) , 0, 12), </SPAN><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Courier New'; color: maroon;">[Generic Drug Indicator]</SPAN><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Courier New'; color: black;"> = 'YES') </SPAN></P><P></P><P>This does not filter the results with the 'Generic Drug Indicator' with the value remaining the same without this.&nbsp; Can you kindly suggest the correct syntax for this expression.</P><P></P><P>Regards.</P></BODY></HTML> Thu, 19 Nov 2015 00:05:18 GMT https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/936673#M953817 Anonymous 2015-11-19T00:05:18Z Re: Expression Syntax https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/936674#M953818 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><SPAN style="color: #575757;"><SPAN style="font-family: arial, helvetica, sans-serif;"><STRONG>RangeSum</STRONG></SPAN><STRONG style="font-family: arial, helvetica, sans-serif;"><SPAN lang="EN-US">(</SPAN><SPAN lang="EN-US">Above</SPAN><SPAN lang="EN-US">(TOTOAL </SPAN><SPAN lang="EN-US">Sum</SPAN><SPAN lang="EN-US">({&lt;<SPAN lang="EN-US">[Generic Drug Indicator]</SPAN><SPAN lang="EN-US"> = {'YES'}</SPAN>&gt;}</SPAN><SPAN lang="EN-US">Amount</SPAN><SPAN lang="EN-US">) , 0, 12)</SPAN></STRONG><SPAN style="font-family: arial, helvetica, sans-serif;"><STRONG>)</STRONG></SPAN></SPAN></P></BODY></HTML> Thu, 19 Nov 2015 00:06:49 GMT https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/936674#M953818 sunny_talwar 2015-11-19T00:06:49Z Re: Expression Syntax https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/936675#M953819 <HTML><HEAD></HEAD><BODY><P>Many thanks Sunny, most appreciated</P></BODY></HTML> Thu, 19 Nov 2015 00:43:40 GMT https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/936675#M953819 Anonymous 2015-11-19T00:43:40Z Re: Expression Syntax https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/936676#M953820 <HTML><HEAD></HEAD><BODY><P>Not a problem. I am glad I have been helpful all day today <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 19 Nov 2015 00:55:38 GMT https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/936676#M953820 sunny_talwar 2015-11-19T00:55:38Z