First off, welcome to QlikView and our community; we're glad to have you!
The answer to your first question is the date expressions built into QlikView. For example, if you want a field which only contains the month value of the "Quote Date", use this code in your load script:
Month([Quote Date]) as Month,
For the second question...QlikView is interpreting the "Quote No" field as a number; it should be treated as text in this case. Try this code:
Text([Quote No]) as [Quote No],
Hi Thanks for helping me so i take it i need to re dit the script at the moment i have the following
[Provider=VFPOLEDB.1;Data Source=C:\USERS\JOHN.PEPPER\DESKTOP\L_DATA\L DATA\COMP_L.DBC;Mode=Share Deny None;Extended Properties="";User ID="";Mask Password=False;Cache Authentication=False;Encrypt Password=False;Collating Sequence=MACHINE;DSN="";DELETED=True;CODEPAGE=1252;MVCOUNT=16384;ENGINEBEHAVIOR=90;TABLEVALIDATE=3;REFRESH=5;VARCHARMAPPING=False;ANSI=True;REPROCESS=5];
could you just point me in the right direction of where i need to put that code, sorry for the novice question but i am new to all of this.
Thanks for the great info
I have done what you have said and it seems to work, The only thing is i checked on the system for the amount of quotes that were created in Jan 2010 it was 186 and my bar graph displays that correctly however in febuary and the other months it seems to add the amounts of the previous months so for Febuary it saying 440 when its actually a lot less than that, is this a sum problem do you think.??