Can you include the script you're using?
Also ... when you run it manually and through the server, are you linking to a database through an ODBC connection? Are you using the same ODBC each time? I've had problems before with different levels of access given to my user id and the server's user id. I have also had problems with slightly different ODBC drivers so make sure the one you're using on your local machine is the same as that on the server.
Thanks for the response. I don't believe the drivers are it because I am running it locally on the server and then using Management Console to rerun the application.
I even tested a very simple process. If you create an application and all you load is this:
Load * INLINE [
Load manually you will get the following results:
Now if you select the 3rd Item you will see the associated Description:
Now if I load the application from the Management Console I will get the following:
Notice the 11007E-0924 is no longer there. Now if I select 11007E-0914 I will get the following results.
It appears that QlikView is trying to group Items that it shouldn't. Try for yourself and see if you get the same results.
From the above attached screenshots, you'll notice that QV is reading the values in as text vs. numbers (left / right alignment indicating this). Seems like QV is interpreting the value as a number in scientific notation. I think -914 and -924 as exponents are exceeding the allowed exponent for floating point values, that's probably why the grouping issue arise here.
Try reading the values in as text (using the text() function in QV LOAD statement).