topic Re: Data changes when load is expanded in QlikView

Data changes when load is expanded

Mon, 30 Apr 2012 19:47:12 GMT

I am trying to load a date function into Qlikview. When I restrict the load to just three accounts the dates pull in correctly (see example).

However, when I unrestrict the load to view all accounts some of the dates do not pull in correctly (see example2).

The OriginalDate on account 0039135 should be 10/11/11 in example2.

Can anyone shed some light on this situation?

Data changes when load is expanded

Nicole-Smith — Mon, 30 Apr 2012 19:57:00 GMT

When you load the OriginalDate field, let QlikView know it is a date:

date(OriginalDate)

You can also specify how you want to date to look if you want to delve into it even further...

Data changes when load is expanded

Mon, 30 Apr 2012 20:11:32 GMT

Nicole,

In the load I am using the following script to specify the date:

Date(Date#(OriginalDate,'YYMMDD'),'MM/DD/YY') as OriginalDate,

It works for most dates but there are a few like the example that are not converting.

Data changes when load is expanded

Nicole-Smith — Tue, 01 May 2012 12:22:56 GMT

Can you post a .qvw with some example data (if you can't share your own data) so that I can take a closer look?

Re: Data changes when load is expanded

Tue, 01 May 2012 16:17:03 GMT

Here is a test .qvw. As you can see PolicyNumberC = 0039135 is pulling correctly when I load the individual PolicyNumberC but if I expand the load it does not pull correctly.

Thanks.

Data changes when load is expanded

Nicole-Smith — Tue, 01 May 2012 16:57:50 GMT

It shows up correctly in the chart if you make your dimension:

=date(OriginalDate)

I'm guessing this may have to do with the way the date is stored in your .qvd file (maybe it is different from the way the other dates are stored)? The above will solve your problem on your chart though.

Data changes when load is expanded

Tue, 01 May 2012 17:05:48 GMT

That seems to have worked. Thanks so much!!