topic Re: set analysis on date in QlikView

set analysis on date

Thu, 18 Aug 2011 20:43:58 GMT

Lot's of threats about this subject on this forum. But still have not found it 😞

The case is simple

Transaction tables runs from 2005 until today

I want to be able to select on year and month in the calendar

Then the transaction table should only show transactions starting on the first day of that year until the last day of the selection.

Example selection: 2009 and March

Table should show all transactions from 1.1.2009 until 31.3.2009

Thanks for your support.

Johan.

chriscammers — Thu, 18 Aug 2011 21:11:14 GMT

It should look something like this, the trick is to override the date selections on the calendar table and then select your date range

Sum({<[Year] = , [Month] = , [Quarter] = , [Date] = {"$(= '>=' & date(YearStart(Max ([Date]))) & '<=' & date(Max([Date])))"}

Fri, 19 Aug 2011 07:04:10 GMT

In one go you got it right. That's amazing!

Thanks a lot, safes me a lot of time and frustrations 🙂