topic Position Date Problem in QlikView

Position Date Problem

pgalvezt — Fri, 08 Aug 2014 18:39:20 GMT

Hello,

I have many tables, one of them has the reception date Test_Consumo_1 (Main Table) , Some codes must be changing with other dates.

I have created an excel file with code and new dates. What I want is change the date excel data into Test_Consumo_1, If not read just the field.

I attached a sample view

Thanks!

Re: Position Date Problem

joshabbott — Fri, 08 Aug 2014 18:40:59 GMT

What is the user id?

Re: Re: Position Date Problem

pgalvezt — Fri, 08 Aug 2014 18:45:34 GMT

I have deleted the credentials,

Re: Re: Position Date Problem

pgalvezt — Fri, 08 Aug 2014 19:23:22 GMT

Hi,

Could you open the file?

Re: Position Date Problem

joshabbott — Fri, 08 Aug 2014 19:53:59 GMT

Yes, I can. But after looking at it, I'm not understanding exactly what you are trying to do though

Re: Re: Position Date Problem

pgalvezt — Fri, 08 Aug 2014 20:02:35 GMT

I have to change the date of some codes for example:

Codigo	Fecha_Prueba	Fecha_Real	fecha_precep	fecha_precep1
L010-OT-00T22337CP	10-08-2013	21-03-2012	21-03-2012	10-08-2013

10-08-2013 have to be into fecha_precep (The real value is 21-03-2013) But If(Codigo is L010-OT-00T22337CP so fecha_precep is Fecha_Prueba if not fecha_precep.

If you want delete the resident tables.