To give a little more detail I am building a dashboard on customer interactions and we have been asked to provide the detail of each interaction (I.E. Email, Reply email etc) and also to provide a count of unique interactions which would count an originating email and a reply as 1 interaction.
My problem is when using this formula locally with my QV development client the formula works perfectly however, when its loaded to our QV server (Version 11 Also) the formula displays different results.
For reference both the client and server version of this dashboard are loaded with the identical recordset.
Please upload a sample file or the code that works outside Qlikview. Maybe screenshots of both, so we can understand your issue.
You could have a link to extra data on the server that is affecting the calculation or maybe a longshot, but your date format on the server may be different to your client, thus DD/MM/YY on your client works, while MM/DD/YY on the server cause lines to fail.
Use Debug and step through an update on the Client and you may be able to see where it is skipping something that the server doesn't e.g. a linked excel file.
If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer
Thanks for your response, I have copied the client directly to the DEV server and refreshed the dashboard reviewed the QV document through access point and then copied the file back from the server to my local machine and openend in the QV client. So now both have the same data loaded and the same formula. However the formula results are different on the QV server vs Client. Really strange! With regards to date formats, It is only certain formulas that are i,mpacted other like simple SUM or Count work fine.
Thanks for your reply, as per my response above I have refreshed the data on the dev server and then copied the QV client locally and still I get different reults for the above formula however, simple counts and sums are working fine. Really strange!