topic Re: Problem with numeric values in QlikView https://community.qlik.com/t5/QlikView/Problem-with-numeric-values/m-p/1198598#M883372 <HTML><HEAD></HEAD><BODY><P>Instead of image values what values you are expecting. </P></BODY></HTML> Mon, 03 Oct 2016 17:03:27 GMT Anil_Babu_Samineni 2016-10-03T17:03:27Z Problem with numeric values https://community.qlik.com/t5/QlikView/Problem-with-numeric-values/m-p/1198596#M883370 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a problem loading a table when I try to concatenate different columns into one dimension. The problem basically is that I lost one of the fields that is related with the year.</P><P>Loading the column alone into one dimension gives no problem (on the image the dimension EJERCICIO) but using concatenation </P><P>EJERCICIO&amp;num(mes,'00')&amp;'-'&amp;ID_EMPRESA&amp;'-'&amp;ID_TRABAJADOR results in the example of pk_TieEmpleado_key where the year doesn't appear.</P><P>The only way I find to solve it is to force EJERCICIO inside num() num(<SPAN style="font-size: 13.3333px;">EJERCICIO)&amp;num(mes,'00')&amp;'-'&amp;ID_EMPRESA&amp;'-'&amp;ID_TRABAJADOR but I would like to understand the problem.</SPAN></P><P><SPAN style="font-size: 13.3333px;">On the database the column EJERCICIO is numeric.</SPAN></P><P></P><P>Thanks for you help.</P><P></P><P>Regards </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Problem-with-numeric-values/m-p/1198596#M883370 2020-11-25T16:16:04Z Re: Problem with numeric values https://community.qlik.com/t5/QlikView/Problem-with-numeric-values/m-p/1198597#M883371 <HTML><HEAD></HEAD><BODY><P>Can you share some sample data and a qvw file if possible ?</P></BODY></HTML> Mon, 03 Oct 2016 16:53:32 GMT https://community.qlik.com/t5/QlikView/Problem-with-numeric-values/m-p/1198597#M883371 vishsaggi 2016-10-03T16:53:32Z Re: Problem with numeric values https://community.qlik.com/t5/QlikView/Problem-with-numeric-values/m-p/1198598#M883372 <HTML><HEAD></HEAD><BODY><P>Instead of image values what values you are expecting. </P></BODY></HTML> Mon, 03 Oct 2016 17:03:27 GMT https://community.qlik.com/t5/QlikView/Problem-with-numeric-values/m-p/1198598#M883372 Anil_Babu_Samineni 2016-10-03T17:03:27Z