How to display each day in month for selection

[#1]

I currently have a table containing information on transactions that customers have made in the current month so far, with a TransactionDate field and a SalesValue field included. I am trying to design a sheet so that the user can select a day of the current month, and the sheet display the total SalesValue collected on that day.

The problem is that I want to be able to show results for every day of the month, not just those that have transactions linked to them. Even if the values shown are 0, it would have a sense of professionalism and completeness about it from the end users point of view.

Can anyone help me with this? Is there a way of Qlikview automatically generating the days for selection, and then results being shown for whichever day is selected?

[#2]

Generate a table with all possible dates and make sure the date field name matches your date field.

Ex:

Transactions:

LOAD TRANSACTION_NUMBER, TRANSACTION_DATE, TRANSACTION_AMOUNT;

SQL .....

DATES:

Load rowno() + $(StartDate) -1 as TRANSACTION_DATE

AUTOGENERATE $(NumberOfDays)

This assumes that you have variables for StartDate & Number of Days