topic Re: expression in a text box in QlikView https://community.qlik.com/t5/QlikView/expression-in-a-text-box/m-p/376468#M140344 <HTML><HEAD></HEAD><BODY><P>it will give u result on selection only.... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P>What exactly you want</P></BODY></HTML> Thu, 09 Aug 2012 09:36:33 GMT rajni_batra 2012-08-09T09:36:33Z expression in a text box https://community.qlik.com/t5/QlikView/expression-in-a-text-box/m-p/376467#M140343 <HTML><HEAD></HEAD><BODY><P>Hey guys,</P><P>Is there any constraints on expressions which can be used in a text box?</P><P>i am trying to use this expression in my text box:</P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN><SPAN style="font-size: 8pt;">='Data as of: ' &amp;(<SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Time Bucket Name]</SPAN><SPAN style="font-size: 8pt;">= 'Current Month' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">and</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Time Bucket Type]</SPAN><SPAN style="font-size: 8pt;">= 'CURRENT', </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">MonthEnd</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Calendar Date]</SPAN><SPAN style="font-size: 8pt;">), 'DD-MMM-YYYY'))) </SPAN></SPAN></P><P> but i am getting the output as: Data as of only.</P><P></P><P>how can i solve this problem?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P></P><P></P><P></P></BODY></HTML> Thu, 09 Aug 2012 09:02:17 GMT https://community.qlik.com/t5/QlikView/expression-in-a-text-box/m-p/376467#M140343 2012-08-09T09:02:17Z Re: expression in a text box https://community.qlik.com/t5/QlikView/expression-in-a-text-box/m-p/376468#M140344 <HTML><HEAD></HEAD><BODY><P>it will give u result on selection only.... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P>What exactly you want</P></BODY></HTML> Thu, 09 Aug 2012 09:36:33 GMT https://community.qlik.com/t5/QlikView/expression-in-a-text-box/m-p/376468#M140344 rajni_batra 2012-08-09T09:36:33Z