1 Reply Latest reply: Sep 28, 2011 5:43 PM by Miguel Angel Baeyens de Arce RSS

    How to create selectable time period blocks in a QVW file?

      I'm trying to provide few drill down options for the display of table objects (project entries) based on time. I'd like to let the users be able to look at projects based on Quarter (Q1, Q2, Q3, Q4), Year (2008, 2009, 2010, 2011) or Month (Jan - Dec). At the moment, they're able to drill down projects based on the creation date. But, I'd like these individual periods to be selectable on a given QlikView File. How do I implement something like this? Do I need to make modifications in the DB to implement this functionality? Is it possible to use the file based functions? I don't have any available fields for quarter, year, or month.

       

      I've attached a picture to illustrate what I'm looking for.

       

      Thanks in advance!