topic Re: Access values with different tags in QlikView https://community.qlik.com/t5/QlikView/Access-values-with-different-tags/m-p/945698#M959900 <HTML><HEAD></HEAD><BODY><P>Thank you... It worked</P></BODY></HTML> Thu, 22 Oct 2015 14:07:02 GMT slribeiro 2015-10-22T14:07:02Z Access values with different tags https://community.qlik.com/t5/QlikView/Access-values-with-different-tags/m-p/945696#M959898 <HTML><HEAD></HEAD><BODY><P>[Production1]:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Ano, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Quantidade, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Consultório, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Mês, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Unidade de Negócio], </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Valor,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 'Produção1' as TipoDados</P><P>FROM</P><P>[..\3.QVD\Source\Produção1.qvd]</P><P>(qvd);</P><P></P><P>[Production2]:</P><P>LOAD </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Ano, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Consultório,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Mês, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Quantidade, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Unidade de Negócio], </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Valor,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 'Production2<SPAN style="font-size: 13.3333px; line-height: 1.5em;">'</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"> as TipoDados</SPAN></P><P>FROM</P><P>[..\3.QVD\Source\Production2.qvd]</P><P>(qvd);</P><P></P><P>RENAME Table [Production1] to [Fact Table];</P><P></P><P>-----------------------------------------------------------------------------------------</P><P></P><P>This is the script i have.</P><P>I want to know how do i set an expression that calculates the " sum({$&lt;Mês = {$(=max(Mês))}, Ano = {$(=max(Ano)) }&gt;} Valor) " but only of Production2.</P><P>Please help me if you can...</P></BODY></HTML> Thu, 22 Oct 2015 11:29:34 GMT https://community.qlik.com/t5/QlikView/Access-values-with-different-tags/m-p/945696#M959898 slribeiro 2015-10-22T11:29:34Z Re: Access values with different tags https://community.qlik.com/t5/QlikView/Access-values-with-different-tags/m-p/945697#M959899 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>just add <SPAN style="font-size: 10pt;">TipoDados={'Production2'} to the set analysis.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">sum({$&lt;Mês = {$(=max(Mês))}, Ano = {$(=max(Ano)) }<SPAN style="color: #ff0000;">, </SPAN><SPAN style="color: #ff0000; font-size: 10pt;">TipoDados={'Production2'}</SPAN>&gt;} Valor)</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Regards</SPAN></P><P><SPAN style="font-size: 10pt;">Sebastian Lettner<BR /></SPAN></P></BODY></HTML> Thu, 22 Oct 2015 13:09:21 GMT https://community.qlik.com/t5/QlikView/Access-values-with-different-tags/m-p/945697#M959899 sebastianlettner 2015-10-22T13:09:21Z Re: Access values with different tags https://community.qlik.com/t5/QlikView/Access-values-with-different-tags/m-p/945698#M959900 <HTML><HEAD></HEAD><BODY><P>Thank you... It worked</P></BODY></HTML> Thu, 22 Oct 2015 14:07:02 GMT https://community.qlik.com/t5/QlikView/Access-values-with-different-tags/m-p/945698#M959900 slribeiro 2015-10-22T14:07:02Z