topic Re: Syntax in Text box in QlikView https://community.qlik.com/t5/QlikView/Syntax-in-Text-box/m-p/951925#M327394 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P><SPAN style="color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;"><STRONG>='Grand Total: ' &amp; <SPAN style="color: #ff0000;">(</SPAN>C</STRONG></SPAN><STRONG style="color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;">ount({&lt;[FLAG1]={'E'}&gt;} DISTINCT TEST_CASE_ID) + Count({&lt;[FLAG1]={'C'}&gt;}DISTINCT TEST_CASE_ID</STRONG><SPAN style="color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;"><STRONG>)<SPAN style="color: #ff0000;">)</SPAN></STRONG></SPAN></P></BODY></HTML> Mon, 28 Sep 2015 21:27:54 GMT sunny_talwar 2015-09-28T21:27:54Z Syntax in Text box https://community.qlik.com/t5/QlikView/Syntax-in-Text-box/m-p/951924#M327393 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please correct the below syntax.&nbsp; It's not working.</P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P><SPAN style="font-size: 8pt;">='Grand Total: ' &amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(<BR /> {&lt;<BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[FLAG1]</SPAN><SPAN style="font-size: 8pt;">={'E'}<BR /> &gt;}<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">TEST_CASE_ID</SPAN><SPAN style="font-size: 8pt;">) +<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(<BR /> {&lt;<BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[FLAG1]</SPAN><SPAN style="font-size: 8pt;">={'C'}<BR /> &gt;}<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">TEST_CASE_ID</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P>Here, 'Grand Totat' alone is working fine or the expression part alone is working fine.&nbsp; However, I couldn't combine both and get the results..</P><P></P><P>Thanks,</P><P>Sudha.</P></BODY></HTML> Mon, 28 Sep 2015 17:45:52 GMT https://community.qlik.com/t5/QlikView/Syntax-in-Text-box/m-p/951924#M327393 2015-09-28T17:45:52Z Re: Syntax in Text box https://community.qlik.com/t5/QlikView/Syntax-in-Text-box/m-p/951925#M327394 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P><SPAN style="color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;"><STRONG>='Grand Total: ' &amp; <SPAN style="color: #ff0000;">(</SPAN>C</STRONG></SPAN><STRONG style="color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;">ount({&lt;[FLAG1]={'E'}&gt;} DISTINCT TEST_CASE_ID) + Count({&lt;[FLAG1]={'C'}&gt;}DISTINCT TEST_CASE_ID</STRONG><SPAN style="color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;"><STRONG>)<SPAN style="color: #ff0000;">)</SPAN></STRONG></SPAN></P></BODY></HTML> Mon, 28 Sep 2015 21:27:54 GMT https://community.qlik.com/t5/QlikView/Syntax-in-Text-box/m-p/951925#M327394 sunny_talwar 2015-09-28T21:27:54Z