topic What to do with 2 diferent Month fields??? in QlikView https://community.qlik.com/t5/QlikView/What-to-do-with-2-diferent-Month-fields/m-p/300465#M579775 <HTML><HEAD></HEAD><BODY><P> Hi all, I have 2 diferent months fields, what can I do to get just one month?</P><P></P><P></P><P>I attached the app.</P><P></P><P></P><P></P><P>Thank you all!!</P></BODY></HTML> Mon, 23 Jan 2012 22:26:43 GMT 2012-01-23T22:26:43Z What to do with 2 diferent Month fields??? https://community.qlik.com/t5/QlikView/What-to-do-with-2-diferent-Month-fields/m-p/300465#M579775 <HTML><HEAD></HEAD><BODY><P> Hi all, I have 2 diferent months fields, what can I do to get just one month?</P><P></P><P></P><P>I attached the app.</P><P></P><P></P><P></P><P>Thank you all!!</P></BODY></HTML> Mon, 23 Jan 2012 22:26:43 GMT https://community.qlik.com/t5/QlikView/What-to-do-with-2-diferent-Month-fields/m-p/300465#M579775 2012-01-23T22:26:43Z What to do with 2 diferent Month fields??? https://community.qlik.com/t5/QlikView/What-to-do-with-2-diferent-Month-fields/m-p/300466#M579776 <HTML><HEAD></HEAD><BODY><P class="jive-username-link-wrapper">Hi <A _jive_internal="true" class="jiveTT-hover-user jive-username-link" href="https://community.qlik.com/people/javierortiz" id="jive-7086415821647602969054" onmouseout="" onmouseover="">javierortiz</A>&nbsp; :</P><P class="jive-username-link-wrapper"></P><P class="jive-username-link-wrapper">You should concatenate both tables Entradas and Presupuestos in order to obtain a unique fact table. Using this strategy you will have an unique Month Field. As you can guess you will need to add a Field in order to be able to get Entradas or Presupuestos as you need. Just create a new field on that fact table, in example for Entradas --&gt; 'Entradas' as Tipo_Hecho. </P><P class="jive-username-link-wrapper"></P><P class="jive-username-link-wrapper">Hope it helps</P><P class="jive-username-link-wrapper"></P><P class="jive-username-link-wrapper">Regards.</P></BODY></HTML> Tue, 24 Jan 2012 07:23:07 GMT https://community.qlik.com/t5/QlikView/What-to-do-with-2-diferent-Month-fields/m-p/300466#M579776 forte 2012-01-24T07:23:07Z