topic Re: Qlikview Text box in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Text-box/m-p/10070#M1554 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">='Tickets Status'&nbsp; &amp;' '&amp; Date<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">(<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #575757;">T</SPAN></SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #575757;">o</SPAN>day() - 30<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">)</SPAN> &amp;' - '&amp; Date(Today())</STRONG></P></BODY></HTML> Mon, 12 Feb 2018 14:20:35 GMT ychaitanya 2018-02-12T14:20:35Z Qlikview Text box https://community.qlik.com/t5/QlikView/Qlikview-Text-box/m-p/10068#M1552 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">='Tickets '&amp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Status</SPAN><SPAN style="font-size: 8pt;">&nbsp; &amp;' '&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">today</SPAN><SPAN style="font-size: 8pt;">()-30 &amp;' - '&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">today</SPAN><SPAN style="font-size: 8pt;">() </SPAN> is the expression I gave in text box</P><P>the required output is Tickets Status 14-01-2017 - 12-02-2017</P><P></P><P>but I am getting - 12-02-2017</P><P></P><P>require help on this</P></BODY></HTML> Mon, 12 Feb 2018 12:35:42 GMT https://community.qlik.com/t5/QlikView/Qlikview-Text-box/m-p/10068#M1552 navaneeth79 2018-02-12T12:35:42Z Re: Qlikview Text box https://community.qlik.com/t5/QlikView/Qlikview-Text-box/m-p/10069#M1553 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>='Tickets '&amp; Status&nbsp; &amp;' '&amp; <SPAN style="color: #ff0000;">(<SPAN style="color: #575757;">T</SPAN></SPAN><SPAN style="color: #575757;">o</SPAN>day() - 30<SPAN style="color: #ff0000;">)</SPAN> &amp;' - '&amp; Today()</STRONG></P></BODY></HTML> Mon, 12 Feb 2018 12:39:49 GMT https://community.qlik.com/t5/QlikView/Qlikview-Text-box/m-p/10069#M1553 sunny_talwar 2018-02-12T12:39:49Z Re: Qlikview Text box https://community.qlik.com/t5/QlikView/Qlikview-Text-box/m-p/10070#M1554 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">='Tickets Status'&nbsp; &amp;' '&amp; Date<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">(<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #575757;">T</SPAN></SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #575757;">o</SPAN>day() - 30<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">)</SPAN> &amp;' - '&amp; Date(Today())</STRONG></P></BODY></HTML> Mon, 12 Feb 2018 14:20:35 GMT https://community.qlik.com/t5/QlikView/Qlikview-Text-box/m-p/10070#M1554 ychaitanya 2018-02-12T14:20:35Z Re: Qlikview Text box https://community.qlik.com/t5/QlikView/Qlikview-Text-box/m-p/10071#M1555 <HTML><HEAD></HEAD><BODY><P>Try below expression.</P><P></P><P><SPAN style="font-size: 8pt;">='Tickets '&amp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Today</SPAN><SPAN style="font-size: 8pt;">() - 30,'DD-MM-YYYY') &amp;' - '&amp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Today</SPAN><SPAN style="font-size: 8pt;">(),'DD-MM-YYYY') </SPAN></P></BODY></HTML> Mon, 12 Feb 2018 16:06:39 GMT https://community.qlik.com/t5/QlikView/Qlikview-Text-box/m-p/10071#M1555 krishnacbe 2018-02-12T16:06:39Z