Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
alexis
Partner - Specialist
Partner - Specialist

Date..From/To selection using Set Analysis

Hi

A small subset of my schema looks as follows:

screen1.jpg

My rich Calendar table is linked to my Fact table via the AcceptDate field and all the date related selections work as expected. Selecting Year, Quarter, Month etc works as expected returning all the correct data in the table and "Filters" Multi-select box (see below).

The user however has requested a "Start Date" "End Date" facility which I have built for them utilising variable vStartDate and vEndDate for calculating the amount totals in the table using Set Analysis as shown below - this also works fine.

Sum({< AcceptDate = {'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'} >} CUSTOMSAMOUNT)

Problem:

The available options in the "Filters" multi-box do not truly reflect reality as they ignore the date range selected and you may be presented with a selection which when chosen does not generate results. Can anyone suggest an approach that will cater for this anomaly?

screen2.jpg

1 Reply
Gysbert_Wassenaar

Perhaps this tutorial is what you need: Selecting Arbitrary Date Ranges


talk is cheap, supply exceeds demand