topic Different format date in QlikView

Different format date

fkeuroglian — Mon, 23 Nov 2015 12:33:50 GMT

Hi expert, i have a situation:

I have a month year column and two tables that are relation by this field

between this two table the values are the same , but do not match

i attached an image explain, i believe that is the format but is the totaly the same

attached the qvw and the qvd for example, thank you a lot

Fernando K.

Re: Different format date

Anonymous — Mon, 23 Nov 2015 15:34:57 GMT

The screenshot that, in one table, you're storing a number (dates are numbers), and applying the month-year format. These are the values that are right-aligned. When you're seeing items that are left-aligned, QlikView isn't recognizing them as the same thing. It's seeing a string, which doesn't matching the date from the other table.

I can't open the QVW in personal edition to give you exact steps, but if you synch both tables so that the key column is either a string in both or a valid date in both, you should get the matching that you're looking for.

Good luck!

Re: Different format date

Anonymous — Mon, 23 Nov 2015 16:01:02 GMT

Hi,

You should force a date format, like this:

makedate(subfield(%MesAno,'-',2),subfield(%MesAno,'-',1),'01') as %MesAno

Re: Different format date

Mark_Little — Mon, 23 Nov 2015 16:09:22 GMT

Hi,

I would say you problem comes from the below line

SuperficieTotal+if (isnull (peek ('Acumulada')),0,peek ('Acumulada')) as Acumulada

As it look like you are taking a date and adding a value, give you the strange number format after a number of if and peeks. what are you trying to do here? Add days?

Mark