topic Re: Text in QlikView https://community.qlik.com/t5/QlikView/Text/m-p/67775#M779043 <HTML><HEAD></HEAD><BODY><P>May be using Only or Concat or MinString or MaxString</P></BODY></HTML> Fri, 06 Apr 2018 08:52:43 GMT sunny_talwar 2018-04-06T08:52:43Z Text https://community.qlik.com/t5/QlikView/Text/m-p/67774#M779042 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I would like to allow users to upload comments into a dashboard.</P><P></P><P>The comments are organized like:</P><P></P><P>Category Region Premium Comment</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>..</P><P>10</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>..</P><P>10</P><P>..</P><P></P><P>If I sum up the premium in a text box I can use the following formula:</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Num</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;Category={</SPAN><SPAN style="font-size: 8pt;">'7'}, Premium</SPAN><SPAN style="font-size: 8pt;"><BR /> ,'#.###,', ',', '.') </SPAN></P><P></P><P>Is there a function where I can define that I only want the text from the comment made for category 7.</P><P></P><P>Like Text({&lt;Category={'7'}&gt;}.</P><P></P><P>Many thanks for your help.</P><P></P><P>Jan</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Text/m-p/67774#M779042 schumi1980 2020-11-25T16:16:04Z Re: Text https://community.qlik.com/t5/QlikView/Text/m-p/67775#M779043 <HTML><HEAD></HEAD><BODY><P>May be using Only or Concat or MinString or MaxString</P></BODY></HTML> Fri, 06 Apr 2018 08:52:43 GMT https://community.qlik.com/t5/QlikView/Text/m-p/67775#M779043 sunny_talwar 2018-04-06T08:52:43Z