topic Re: TextBox in QlikView https://community.qlik.com/t5/QlikView/TextBox/m-p/1388668#M820292 <HTML><HEAD></HEAD><BODY><P>Concat(Distinct&nbsp; Region, ',')</P><P></P><P>This will give you comma separated values.</P></BODY></HTML> Fri, 11 Aug 2017 10:38:47 GMT tresB 2017-08-11T10:38:47Z TextBox https://community.qlik.com/t5/QlikView/TextBox/m-p/1388667#M820291 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I have small doubt..</P><P></P><P>I have dimension like </P><P></P><P>Region</P><P>----------</P><P>North</P><P>south</P><P>east</P><P>west</P><P></P><P></P><P></P><P>so these values I want to display in text box&nbsp;&nbsp; how can I do this?&nbsp;&nbsp; Is there any specific function?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/TextBox/m-p/1388667#M820291 soniasweety 2020-11-25T16:16:04Z Re: TextBox https://community.qlik.com/t5/QlikView/TextBox/m-p/1388668#M820292 <HTML><HEAD></HEAD><BODY><P>Concat(Distinct&nbsp; Region, ',')</P><P></P><P>This will give you comma separated values.</P></BODY></HTML> Fri, 11 Aug 2017 10:38:47 GMT https://community.qlik.com/t5/QlikView/TextBox/m-p/1388668#M820292 tresB 2017-08-11T10:38:47Z Re: TextBox https://community.qlik.com/t5/QlikView/TextBox/m-p/1388669#M820293 <HTML><HEAD></HEAD><BODY><P>Nice&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> thank you </P></BODY></HTML> Fri, 11 Aug 2017 10:44:05 GMT https://community.qlik.com/t5/QlikView/TextBox/m-p/1388669#M820293 soniasweety 2017-08-11T10:44:05Z Re: TextBox https://community.qlik.com/t5/QlikView/TextBox/m-p/1388670#M820294 <HTML><HEAD></HEAD><BODY><P>And one more thing</P><P><A _jive_internal="true" class="jiveTT-hover-user jive-username-link" data-avatarid="2991" data-externalid="" data-presence="null" data-userid="26418" data-username="tresesco" href="https://community.qlik.com/people/tresesco"><STRONG style=": ; color: #0066cc; text-decoration: underline;">Tresesco B</STRONG></A></P><P>I want to load only&nbsp; south,east from that field&nbsp; </P><P></P><P>I want to load as optimized&nbsp; how can I do ? I don't want to use where condition.?</P></BODY></HTML> Fri, 11 Aug 2017 10:45:25 GMT https://community.qlik.com/t5/QlikView/TextBox/m-p/1388670#M820294 soniasweety 2017-08-11T10:45:25Z Re: TextBox https://community.qlik.com/t5/QlikView/TextBox/m-p/1388671#M820295 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P>filter:&nbsp; </P><P>Load Filter Inline [</P><P><STRONG>Filter</STRONG></P><P>south</P><P>east</P><P>];</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Region</P><P>From &lt;qvd path&gt; <STRONG>where exists(Filter, Region);</STRONG></P><P>Drop table filter;</P></BODY></HTML> Fri, 11 Aug 2017 10:52:40 GMT https://community.qlik.com/t5/QlikView/TextBox/m-p/1388671#M820295 tresB 2017-08-11T10:52:40Z Re: TextBox https://community.qlik.com/t5/QlikView/TextBox/m-p/1388672#M820296 <HTML><HEAD></HEAD><BODY><P>Ohh if I use exists function it is optimized? </P></BODY></HTML> Fri, 11 Aug 2017 10:54:47 GMT https://community.qlik.com/t5/QlikView/TextBox/m-p/1388672#M820296 soniasweety 2017-08-11T10:54:47Z Re: TextBox https://community.qlik.com/t5/QlikView/TextBox/m-p/1388673#M820297 <HTML><HEAD></HEAD><BODY><P>Yes, it is still optimized. Read this: <A href="https://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/" title="https://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/">qlikview-optimised-qvd-loads</A></P></BODY></HTML> Fri, 11 Aug 2017 10:58:16 GMT https://community.qlik.com/t5/QlikView/TextBox/m-p/1388673#M820297 tresB 2017-08-11T10:58:16Z Re: TextBox https://community.qlik.com/t5/QlikView/TextBox/m-p/1388674#M820298 <HTML><HEAD></HEAD><BODY><P>thanks I will go through it&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 11 Aug 2017 11:00:35 GMT https://community.qlik.com/t5/QlikView/TextBox/m-p/1388674#M820298 soniasweety 2017-08-11T11:00:35Z Re: TextBox https://community.qlik.com/t5/QlikView/TextBox/m-p/1388675#M820299 <HTML><HEAD></HEAD><BODY><P>its giving page not displayed <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Fri, 11 Aug 2017 11:01:00 GMT https://community.qlik.com/t5/QlikView/TextBox/m-p/1388675#M820299 soniasweety 2017-08-11T11:01:00Z Re: TextBox https://community.qlik.com/t5/QlikView/TextBox/m-p/1388676#M820300 <HTML><HEAD></HEAD><BODY><P>It's an active page. Possibly your network is restricting it. Please check.</P></BODY></HTML> Fri, 11 Aug 2017 11:03:00 GMT https://community.qlik.com/t5/QlikView/TextBox/m-p/1388676#M820300 tresB 2017-08-11T11:03:00Z Re: TextBox https://community.qlik.com/t5/QlikView/TextBox/m-p/1388677#M820301 <HTML><HEAD></HEAD><BODY><P>Ok thank you .I will check at home </P></BODY></HTML> Fri, 11 Aug 2017 11:05:27 GMT https://community.qlik.com/t5/QlikView/TextBox/m-p/1388677#M820301 soniasweety 2017-08-11T11:05:27Z