topic Re: Using Variables in Expressions in Brasil https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22125#M1137 <HTML><HEAD></HEAD><BODY><P>Hehe boa. Bem, tem como disponibilizar um qvf de exemplo?</P></BODY></HTML> Wed, 11 Apr 2018 19:11:38 GMT Thiago_Justen_ 2018-04-11T19:11:38Z Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22115#M1127 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="199325" alt="expressions.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/199325_expressions.PNG" style="height: 318px; width: 620px;" /></P><P></P><P>I have two variables called (vReferencia) and (vFamilia), but when i use (vFamilia) inside an expression with (vReferencia), it returns "-".</P><P></P><P>Where am i going wrong ?</P></BODY></HTML> Wed, 11 Apr 2018 17:26:04 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22115#M1127 eduardopicolli 2018-04-11T17:26:04Z Re: Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22116#M1128 <HTML><HEAD></HEAD><BODY><P>Eduardo,</P><P></P><P>What is the expression for vReferencia? I guess we are able to text in portuguese, right?</P><P></P><P>Provavelmente sua expressão para vReferencia retorna mais de um valor possível e por isso no KPI ocorre esse '-'.</P><P></P><P>Deixe-nos avaliar sua expressão e dê mais detalhes, especialmente sobre o output esperado.</P><P></P><P>Abs e Sucesso!</P></BODY></HTML> Wed, 11 Apr 2018 18:21:35 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22116#M1128 Thiago_Justen_ 2018-04-11T18:21:35Z Re: Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22117#M1129 <HTML><HEAD></HEAD><BODY><P>How about this may be</P><P></P><P><STRONG>If(Len(Trim($(vReferencia))) &gt; 0, $(vReferencia), $(vFamilia))</STRONG></P></BODY></HTML> Wed, 11 Apr 2018 18:29:20 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22117#M1129 sunny_talwar 2018-04-11T18:29:20Z Re: Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22118#M1130 <HTML><HEAD></HEAD><BODY><P>Hey <A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>, what's up friend? Sometimes I think you are a kind of Qlik's robot. You're everywhere! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Wed, 11 Apr 2018 18:35:13 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22118#M1130 Thiago_Justen_ 2018-04-11T18:35:13Z Re: Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22119#M1131 <HTML><HEAD></HEAD><BODY><P>You are not the only one that thinks that way <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />... I am good... how are you?</P></BODY></HTML> Wed, 11 Apr 2018 18:36:06 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22119#M1131 sunny_talwar 2018-04-11T18:36:06Z Re: Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22120#M1132 <HTML><HEAD></HEAD><BODY><P>I'm doing good, man. Glad to see you here! </P></BODY></HTML> Wed, 11 Apr 2018 18:39:26 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22120#M1132 Thiago_Justen_ 2018-04-11T18:39:26Z Re: Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22121#M1133 <HTML><HEAD></HEAD><BODY><P><IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/199326_1.PNG" style="height: 466px; width: 620px;" /></P><P>Seguinte, no primeiro exemplo eu tenho o meu campo Referencia filtrado com o valor '77650187' e na minha (vReferencia) ele retorna o valor certo, e na (vFamilia) o valor respectivo da sua familia. No segundo exemplo eu tenho o campo Familia filtrado, e ele deveria me retornar o valor da Familia.</P></BODY></HTML> Wed, 11 Apr 2018 18:42:51 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22121#M1133 eduardopicolli 2018-04-11T18:42:51Z Re: Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22122#M1134 <HTML><HEAD></HEAD><BODY><P>Heey, it doesn't work. Thanks!</P></BODY></HTML> Wed, 11 Apr 2018 18:43:36 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22122#M1134 eduardopicolli 2018-04-11T18:43:36Z Re: Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22123#M1135 <HTML><HEAD></HEAD><BODY><P>Funcionou ou não? Hehe, você agradeceu mas disse que não funcionou?!?! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P></BODY></HTML> Wed, 11 Apr 2018 18:56:40 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22123#M1135 Thiago_Justen_ 2018-04-11T18:56:40Z Re: Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22124#M1136 <HTML><HEAD></HEAD><BODY><P>Não funcionou haha. Agradeci a tentativa! </P></BODY></HTML> Wed, 11 Apr 2018 18:59:49 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22124#M1136 eduardopicolli 2018-04-11T18:59:49Z Re: Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22125#M1137 <HTML><HEAD></HEAD><BODY><P>Hehe boa. Bem, tem como disponibilizar um qvf de exemplo?</P></BODY></HTML> Wed, 11 Apr 2018 19:11:38 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22125#M1137 Thiago_Justen_ 2018-04-11T19:11:38Z Re: Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22126#M1138 <HTML><HEAD></HEAD><BODY><P>Claro, de uma olhada no exemplo lá em cima.</P></BODY></HTML> Wed, 11 Apr 2018 19:57:34 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22126#M1138 eduardopicolli 2018-04-11T19:57:34Z Re: Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22127#M1139 <HTML><HEAD></HEAD><BODY><P>Segue o app alterado para sua apreciação. Agora funciona. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Wed, 11 Apr 2018 20:25:02 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22127#M1139 Thiago_Justen_ 2018-04-11T20:25:02Z Re: Using Variables in Expressions https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22128#M1140 <HTML><HEAD></HEAD><BODY><P>Funcionou perfeitamente Thiago, muito obrigado!</P></BODY></HTML> Thu, 12 Apr 2018 10:13:49 GMT https://community.qlik.com/t5/Brasil/Using-Variables-in-Expressions/m-p/22128#M1140 eduardopicolli 2018-04-12T10:13:49Z