I have worked with Qlickview for only a few days and now have the following problem:
I have two date fields in my address database, VertragBeginn (ContractBegin) and VertragEnde (ContractEnd). If an entry has no date VertragEnde or if the date is set but in the future, the entry has an active contract.
I want to create a diagram showing for each month in the last five years the number of active contracts in that month.
How can I extract the number of active contracts from my adress database for all required months with a single SQL -query?
Can I show the result directly in a diagram or do I have to create a separate table with the columns “month” and “number of active contracts”, so that I can use these columns as dimensions of the diagram?
You may also want to check out this example that uses IntervalMatch to assign a day to each contract. That gives you the flexibility to count by day, month, whatever.
