topic Re: Formula Problem in QlikView https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467221#M174552 <HTML><HEAD></HEAD><BODY><P>Ok I fixed it but really wired.</P><P>Thank you!</P></BODY></HTML> Mon, 26 Nov 2012 19:20:53 GMT pgalvezt 2012-11-26T19:20:53Z Formula Problem https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467211#M174542 <HTML><HEAD></HEAD><BODY><P>Hello, I have this formula: See the picture</P><P></P><P>Works fine in my load model. But when I call the qvd model and I built the same Pivot QlikView drop another Result. Its like if the formula not been working. </P><P></P><P>Thanks!</P></BODY></HTML> Mon, 26 Nov 2012 15:11:54 GMT https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467211#M174542 pgalvezt 2012-11-26T15:11:54Z Re: Formula Problem https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467212#M174543 <HTML><HEAD></HEAD><BODY><P>I know is wire this kind of problem. I don`t know if to someone it happened anytime? So can help me to figure out this problem.</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 26 Nov 2012 15:50:55 GMT https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467212#M174543 pgalvezt 2012-11-26T15:50:55Z Re: Formula Problem https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467213#M174544 <HTML><HEAD></HEAD><BODY><P>I'm seeing this format ('DD/MM/YYYY') in Fecha_Protesto2 in Dibujo2 but this one ('DD-MM-YYYY') in the expression in Dibujo1, that´s correct?? </P></BODY></HTML> Mon, 26 Nov 2012 18:06:32 GMT https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467213#M174544 chematos 2012-11-26T18:06:32Z Re: Formula Problem https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467214#M174545 <HTML><HEAD></HEAD><BODY><P>I don't understand its suppose its about the same format. All the entire information left saved into the qvd right? I don't know why QlikView show another format</P><P>How can I fix that?</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 26 Nov 2012 18:29:33 GMT https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467214#M174545 pgalvezt 2012-11-26T18:29:33Z Re: Formula Problem https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467215#M174546 <HTML><HEAD></HEAD><BODY><P>Could you try each sum in two separated text boxes and copy the results?</P></BODY></HTML> Mon, 26 Nov 2012 18:34:03 GMT https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467215#M174546 chematos 2012-11-26T18:34:03Z Re: Formula Problem https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467216#M174547 <HTML><HEAD></HEAD><BODY><P>I created 2 text boxes. I don't know why FechaProtesto2 Appear with another format.</P></BODY></HTML> Mon, 26 Nov 2012 18:49:32 GMT https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467216#M174547 pgalvezt 2012-11-26T18:49:32Z Re: Formula Problem https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467217#M174548 <HTML><HEAD></HEAD><BODY><P>That´s because on your Main sheet you have defined DateTime format variable as DD/MM/YYYY and when you use date(Fecha....) you get that format so youe need to specify always the format you want like date(Fecha..., 'DD-MM-YYYY') or change you system variable in the Main sheet</P></BODY></HTML> Mon, 26 Nov 2012 18:55:53 GMT https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467217#M174548 chematos 2012-11-26T18:55:53Z Re: Formula Problem https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467218#M174549 <HTML><HEAD></HEAD><BODY><P>I understand that. But. If I created a pivot with a formula. Its suppose that the qvd file takes the same format that my original Load Model.</P></BODY></HTML> Mon, 26 Nov 2012 18:59:43 GMT https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467218#M174549 pgalvezt 2012-11-26T18:59:43Z Re: Formula Problem https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467219#M174550 <HTML><HEAD></HEAD><BODY><P>I think is not like that, QV convert dates to the format of the system variable. Try using the same format for all and look if that works</P></BODY></HTML> Mon, 26 Nov 2012 19:04:23 GMT https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467219#M174550 chematos 2012-11-26T19:04:23Z Re: Formula Problem https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467220#M174551 <HTML><HEAD></HEAD><BODY><P>I change into the formula - for / and worked. But hahaha look the picture. Qlikview is add bad. If a put table and sum total QlikView sum 731 MM but if I put Pivot QlikView sum 721 MM.</P></BODY></HTML> Mon, 26 Nov 2012 19:10:53 GMT https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467220#M174551 pgalvezt 2012-11-26T19:10:53Z Re: Formula Problem https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467221#M174552 <HTML><HEAD></HEAD><BODY><P>Ok I fixed it but really wired.</P><P>Thank you!</P></BODY></HTML> Mon, 26 Nov 2012 19:20:53 GMT https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467221#M174552 pgalvezt 2012-11-26T19:20:53Z Re: Formula Problem https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467222#M174553 <HTML><HEAD></HEAD><BODY><P>You`re welcome </P></BODY></HTML> Mon, 26 Nov 2012 19:43:56 GMT https://community.qlik.com/t5/QlikView/Formula-Problem/m-p/467222#M174553 chematos 2012-11-26T19:43:56Z