Data changes when load is expanded

[#1]

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?

[Nicole-Smith]

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

[#3]

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.

[Nicole-Smith]

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?

[#5]

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.

[Nicole-Smith · Accepted solution]

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.

[#7]

That seems to have worked. Thanks so much!!