topic How to display each day in month for selection in QlikView https://community.qlik.com/t5/QlikView/How-to-display-each-day-in-month-for-selection/m-p/222425#M75098 <HTML><HEAD></HEAD><BODY><P>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.</P><P>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.</P><P>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?</P></BODY></HTML> Thu, 22 Apr 2010 17:20:08 GMT 2010-04-22T17:20:08Z How to display each day in month for selection https://community.qlik.com/t5/QlikView/How-to-display-each-day-in-month-for-selection/m-p/222425#M75098 <HTML><HEAD></HEAD><BODY><P>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.</P><P>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.</P><P>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?</P></BODY></HTML> Thu, 22 Apr 2010 17:20:08 GMT https://community.qlik.com/t5/QlikView/How-to-display-each-day-in-month-for-selection/m-p/222425#M75098 2010-04-22T17:20:08Z How to display each day in month for selection https://community.qlik.com/t5/QlikView/How-to-display-each-day-in-month-for-selection/m-p/222426#M75099 <HTML><HEAD></HEAD><BODY><P>Generate a table with all possible dates and make sure the date field name matches your date field.</P><P>Ex:</P><P>Transactions:</P><P>LOAD TRANSACTION_NUMBER, TRANSACTION_DATE, TRANSACTION_AMOUNT;</P><P>SQL .....</P><P></P><P>DATES:</P><P>Load rowno() + $(StartDate) -1 as TRANSACTION_DATE</P><P>AUTOGENERATE $(NumberOfDays)</P><P>This assumes that you have variables for StartDate &amp; Number of Days</P></BODY></HTML> Thu, 22 Apr 2010 17:42:19 GMT https://community.qlik.com/t5/QlikView/How-to-display-each-day-in-month-for-selection/m-p/222426#M75099 2010-04-22T17:42:19Z