Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis on date

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.

1 Solution

Accepted Solutions
chriscammers
Partner Ambassador
Partner Ambassador

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])))"}

View solution in original post

2 Replies
chriscammers
Partner Ambassador
Partner Ambassador

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])))"}

Not applicable
Author

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

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