topic Show text string with set analysis in an expression in QlikView https://community.qlik.com/t5/QlikView/Show-text-string-with-set-analysis-in-an-expression/m-p/1237410#M853278 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I would like to show text string in an expression applying set analysis. The formula would be:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">Only</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">USERID</SPAN><SPAN style="font-size: 8pt;"> = {'$(=QVUser())'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Action_comment8D</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">The purpose is I have linked regions and USERID, so when the user logs in only data from his región appears. In this case I want to show the information through tables, and since an table object doesnt allow me to use set analysis, I am using pivot table. But the problem is that the field Action_comment8D is a text and I want it to show for every row. With function Only those rows with same comments returns me a null field and using a Maxstring function, those rows with different comments, returns me only the one with máximum number of strings.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Do you know if there is another function or way to represent it?</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Thank you in advance.</SPAN></P><P></P><P></P><P></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Show text string with set analysis in an expression https://community.qlik.com/t5/QlikView/Show-text-string-with-set-analysis-in-an-expression/m-p/1237410#M853278 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I would like to show text string in an expression applying set analysis. The formula would be:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">Only</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">USERID</SPAN><SPAN style="font-size: 8pt;"> = {'$(=QVUser())'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Action_comment8D</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">The purpose is I have linked regions and USERID, so when the user logs in only data from his región appears. In this case I want to show the information through tables, and since an table object doesnt allow me to use set analysis, I am using pivot table. But the problem is that the field Action_comment8D is a text and I want it to show for every row. With function Only those rows with same comments returns me a null field and using a Maxstring function, those rows with different comments, returns me only the one with máximum number of strings.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Do you know if there is another function or way to represent it?</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Thank you in advance.</SPAN></P><P></P><P></P><P></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Show-text-string-with-set-analysis-in-an-expression/m-p/1237410#M853278 2020-11-25T16:16:04Z Re: Show text string with set analysis in an expression https://community.qlik.com/t5/QlikView/Show-text-string-with-set-analysis-in-an-expression/m-p/1237411#M853279 <HTML><HEAD></HEAD><BODY><P>Try to use straight table</P></BODY></HTML> Mon, 27 Feb 2017 12:06:11 GMT https://community.qlik.com/t5/QlikView/Show-text-string-with-set-analysis-in-an-expression/m-p/1237411#M853279 2017-02-27T12:06:11Z Re: Show text string with set analysis in an expression https://community.qlik.com/t5/QlikView/Show-text-string-with-set-analysis-in-an-expression/m-p/1237412#M853280 <HTML><HEAD></HEAD><BODY><P>Can you share a sample of your data for this?</P><P>I'm a bit confused about exactly what and what is not showing for you!</P></BODY></HTML> Mon, 27 Feb 2017 12:32:24 GMT https://community.qlik.com/t5/QlikView/Show-text-string-with-set-analysis-in-an-expression/m-p/1237412#M853280 adamdavi3s 2017-02-27T12:32:24Z