topic Re: The expression in list in QlikView https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288180#M403184 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #212121;"> I want to when filtering the list displayed </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #212121;">if ([Тип данных]='Спутник', [Место установки])</SPAN></P></BODY></HTML> Tue, 22 Nov 2016 07:05:31 GMT 2016-11-22T07:05:31Z The expression in list https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288174#M403178 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;">Hi<BR /></SPAN></P><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;"><BR /></SPAN></P><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;">The list is an expression, but it does not work in this situation.</SPAN></P><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;">I would like to appear on the list only these lines.</SPAN></P><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;"><BR /></SPAN></P><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;">Thanks<BR /></SPAN></P><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;"><BR /></SPAN></P><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;"><BR /></SPAN></P></BODY></HTML> Tue, 22 Nov 2016 05:40:47 GMT https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288174#M403178 2016-11-22T05:40:47Z Re: The expression in list https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288175#M403179 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P>= Concat({&lt;[Тип данных]={'Спутник'}&gt;} DISTINCT [Место установки], ',')</P></BODY></HTML> Tue, 22 Nov 2016 06:30:38 GMT https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288175#M403179 tresB 2016-11-22T06:30:38Z Re: The expression in list https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288176#M403180 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-size: 12pt; font-family: arial, sans-serif;">I would like it to be a filter list</SPAN></P></BODY></HTML> Tue, 22 Nov 2016 06:34:18 GMT https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288176#M403180 2016-11-22T06:34:18Z Re: The expression in list https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288177#M403181 <HTML><HEAD></HEAD><BODY><P>can you explain your requirement with some sample data?</P></BODY></HTML> Tue, 22 Nov 2016 06:35:46 GMT https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288177#M403181 shraddha_g 2016-11-22T06:35:46Z Re: The expression in list https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288178#M403182 <HTML><HEAD></HEAD><BODY><P>Try listbox expression like :</P><P></P><P>=<STRONG>Aggr</STRONG>(if ([Тип данных]='Спутник', [Место установки]),[Место установки])</P></BODY></HTML> Tue, 22 Nov 2016 06:41:45 GMT https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288178#M403182 tresB 2016-11-22T06:41:45Z Re: The expression in list https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288179#M403183 <HTML><HEAD></HEAD><BODY><P>It's not correct(<IMG alt="Clip2net_161122100100.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144459_Clip2net_161122100100.png" style="height: 321px; width: 620px;" /></P></BODY></HTML> Tue, 22 Nov 2016 07:02:51 GMT https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288179#M403183 2016-11-22T07:02:51Z Re: The expression in list https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288180#M403184 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #212121;"> I want to when filtering the list displayed </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #212121;">if ([Тип данных]='Спутник', [Место установки])</SPAN></P></BODY></HTML> Tue, 22 Nov 2016 07:05:31 GMT https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288180#M403184 2016-11-22T07:05:31Z Re: The expression in list https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288181#M403185 <HTML><HEAD></HEAD><BODY><P>A small correction needed, try like:</P><P></P><P>=<STRONG>Aggr</STRONG>(if ([Тип данных]='Спутник', [Место установки]),<STRONG>[Место установки],[Тип данных]</STRONG>)</P></BODY></HTML> Tue, 22 Nov 2016 07:11:02 GMT https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288181#M403185 tresB 2016-11-22T07:11:02Z Re: The expression in list https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288182#M403186 <HTML><HEAD></HEAD><BODY><P>Thanks! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 22 Nov 2016 07:24:30 GMT https://community.qlik.com/t5/QlikView/The-expression-in-list/m-p/1288182#M403186 2016-11-22T07:24:30Z