Formula Problem

[pgalvezt]

Hello, I have this formula: See the picture

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.

Thanks!

[pgalvezt]

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.

Thanks!

[chematos · Accepted solution]

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??

[pgalvezt]

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

How can I fix that?

Thanks!

[chematos]

Could you try each sum in two separated text boxes and copy the results?

[pgalvezt]

I created 2 text boxes. I don't know why FechaProtesto2 Appear with another format.

[chematos]

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

[pgalvezt]

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.

[chematos]

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

[pgalvezt]

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.