Hello John and welcome to the Forums and the QlikView world,
I suggest you to build a master calendar, so you have all possible time related dimensions (days, months, week, and so) in one table and linked to your main fact table (quotes in your case).
Then create a new chart, pivot table, set year and month as dimensions and
Hope that helps
Hi Thanks for the reply i am still having trouble by not being able to dislpay anything.
If i start from the begining when i input the fields by selecting the tables that i want to show ie: quote date and quote number is there a way i can narrow down the data to only show the last year because i have ten years imported at the moment, maybe if i can smaller sized data i could understand it a bit better.
You can narrow your results by just loading a few of them, using a WHERE statement in your LOAD script, for example
LOAD * WHERE Year([Quote Date]) = 2010; SQL SELECT ...
Or you can create a new listbox with year as field, select it and then go to File menu, Reduce Data, keep possible values.
Is that what you are looking for?