topic Re: Current selection value in text object in QlikView https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889830#M1011350 <HTML><HEAD></HEAD><BODY><P>can u explain more</P></BODY></HTML> Thu, 23 Apr 2015 05:11:18 GMT arulsettu 2015-04-23T05:11:18Z Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889826#M1011346 <HTML><HEAD></HEAD><BODY><P>Hi Expert,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; we want Current selection value in text object how to achieve this please suggest.</P></BODY></HTML> Thu, 23 Apr 2015 04:59:20 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889826#M1011346 vijayit43 2015-04-23T04:59:20Z Re: Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889827#M1011347 <HTML><HEAD></HEAD><BODY><P>try this in tex box</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=GetCurrentSelections()</SPAN></P></BODY></HTML> Thu, 23 Apr 2015 05:02:28 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889827#M1011347 arulsettu 2015-04-23T05:02:28Z Re: Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889828#M1011348 <HTML><HEAD></HEAD><BODY><P>check this too</P><P><A href="https://community.qlik.com/docs/DOC-4290">QlikView App: Current Selections Dynamic Display</A></P></BODY></HTML> Thu, 23 Apr 2015 05:03:18 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889828#M1011348 arulsettu 2015-04-23T05:03:18Z Re: Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889829#M1011349 <HTML><HEAD></HEAD><BODY><P>Hi, I Want only One Field Selection value then what to do.</P></BODY></HTML> Thu, 23 Apr 2015 05:07:52 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889829#M1011349 vijayit43 2015-04-23T05:07:52Z Re: Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889830#M1011350 <HTML><HEAD></HEAD><BODY><P>can u explain more</P></BODY></HTML> Thu, 23 Apr 2015 05:11:18 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889830#M1011350 arulsettu 2015-04-23T05:11:18Z Re: Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889831#M1011351 <HTML><HEAD></HEAD><BODY><P>Hi in List Box Period(P1,P2,P3) Filter when we select P1&amp;P2 then Show text Box P1,P2. But anyother selection not show.</P></BODY></HTML> Thu, 23 Apr 2015 05:13:34 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889831#M1011351 vijayit43 2015-04-23T05:13:34Z Re: Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889832#M1011352 <HTML><HEAD></HEAD><BODY><P>=Concat(Period,',')</P></BODY></HTML> Thu, 23 Apr 2015 05:25:33 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889832#M1011352 petter 2015-04-23T05:25:33Z Re: Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889833#M1011353 <HTML><HEAD></HEAD><BODY><P>Its Show Multiple Time..</P></BODY></HTML> Thu, 23 Apr 2015 05:29:43 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889833#M1011353 vijayit43 2015-04-23T05:29:43Z Re: Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889834#M1011354 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">=</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">GetFieldSelections</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">YourFeild</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">) </SPAN></P></BODY></HTML> Thu, 23 Apr 2015 05:33:34 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889834#M1011354 anbu1984 2015-04-23T05:33:34Z Re: Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889835#M1011357 <HTML><HEAD></HEAD><BODY><P>=Concat(<STRONG>DISTINCT</STRONG> Period,',')</P><P></P><P>you can also add sorting/weighting as a third parameter to Concat()</P></BODY></HTML> Thu, 23 Apr 2015 06:09:37 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889835#M1011357 petter 2015-04-23T06:09:37Z Re: Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889836#M1011358 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try Distinct keyword it eliminates the duplicates</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Concat(DISTINCT Period,',')</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">OR you can also use GetFieldSelections(Period)<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Regards,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Jagan.<BR /></SPAN></P></BODY></HTML> Thu, 23 Apr 2015 06:20:38 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889836#M1011358 jagan 2015-04-23T06:20:38Z Re: Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889837#M1011359 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this, if you want Nothing in the text box when nothing is selected from that field..</P><P></P><P>= if(GetSelectedCount(Field Name)=0,'',Concat(DISTINCT <SPAN style="font-size: 13.3333330154419px;">Field Name</SPAN>,','))</P></BODY></HTML> Thu, 23 Apr 2015 06:29:41 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889837#M1011359 2015-04-23T06:29:41Z Re: Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889838#M1011360 <HTML><HEAD></HEAD><BODY><P>Concat() will display all Periods when nothing is selected</P></BODY></HTML> Thu, 23 Apr 2015 06:45:21 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889838#M1011360 anbu1984 2015-04-23T06:45:21Z Re: Current selection value in text object https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889839#M1011361 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Thu, 23 Apr 2015 06:46:54 GMT https://community.qlik.com/t5/QlikView/Current-selection-value-in-text-object/m-p/889839#M1011361 2015-04-23T06:46:54Z