topic Re: string beside expression in QlikView https://community.qlik.com/t5/QlikView/string-beside-expression/m-p/667550#M242765 <HTML><HEAD></HEAD><BODY><P>Yo can ttryyr like this</P><P></P><P>= 'working day' &amp;Count (Distinct{ &lt;[F Sr Net Sales Amount]={"&gt;=0"}&gt;}[Full Date]) </P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 10 Sep 2014 13:18:42 GMT ashfaq_haseeb 2014-09-10T13:18:42Z string beside expression https://community.qlik.com/t5/QlikView/string-beside-expression/m-p/667548#M242763 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i want to show&nbsp; string "working day" beside this code on the caption of a pivot table:</P><P>=Count (Distinct{ &lt;[F Sr Net Sales Amount]={"&gt;=0"}&gt;}[Full Date])</P><P>is it possible?</P></BODY></HTML> Wed, 10 Sep 2014 13:08:32 GMT https://community.qlik.com/t5/QlikView/string-beside-expression/m-p/667548#M242763 2014-09-10T13:08:32Z Re: string beside expression https://community.qlik.com/t5/QlikView/string-beside-expression/m-p/667549#M242764 <HTML><HEAD></HEAD><BODY><P>Use '&amp;' symbol to concat a string, like:</P><P>=Count (Distinct{ &lt;[F Sr Net Sales Amount]={"&gt;=0"}&gt;}[Full Date]) <STRONG>&amp; 'working day'</STRONG></P></BODY></HTML> Wed, 10 Sep 2014 13:12:02 GMT https://community.qlik.com/t5/QlikView/string-beside-expression/m-p/667549#M242764 tresB 2014-09-10T13:12:02Z Re: string beside expression https://community.qlik.com/t5/QlikView/string-beside-expression/m-p/667550#M242765 <HTML><HEAD></HEAD><BODY><P>Yo can ttryyr like this</P><P></P><P>= 'working day' &amp;Count (Distinct{ &lt;[F Sr Net Sales Amount]={"&gt;=0"}&gt;}[Full Date]) </P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 10 Sep 2014 13:18:42 GMT https://community.qlik.com/t5/QlikView/string-beside-expression/m-p/667550#M242765 ashfaq_haseeb 2014-09-10T13:18:42Z Re: string beside expression https://community.qlik.com/t5/QlikView/string-beside-expression/m-p/667551#M242766 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/26418">tresesco</A> said..will work</P><P></P><P>but this as well, if you wana show on start</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=<SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG> 'working day ' <SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&amp; <SPAN style="color: #ff0000; font-size: 12pt;">(</SPAN></STRONG></SPAN></STRONG></SPAN>Count (Distinct{ &lt;[F Sr Net Sales Amount]={"&gt;=0"}&gt;}[Full Date]) <SPAN style="color: #ff0000;"><STRONG style="font-size: 12pt;">)</STRONG></SPAN></SPAN></P></BODY></HTML> Wed, 10 Sep 2014 13:33:09 GMT https://community.qlik.com/t5/QlikView/string-beside-expression/m-p/667551#M242766 israrkhan 2014-09-10T13:33:09Z Re: string beside expression https://community.qlik.com/t5/QlikView/string-beside-expression/m-p/667552#M242767 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.qlik.com/qlik-users/168958">mana azizi</A></P><P>Don't forget to mark your discussion as answered.</P><P>,Thanks</P></BODY></HTML> Wed, 10 Sep 2014 14:00:37 GMT https://community.qlik.com/t5/QlikView/string-beside-expression/m-p/667552#M242767 cheburashka 2014-09-10T14:00:37Z