Date..From/To selection using Set Analysis

alexis — Thu, 04 Jul 2013 11:51:15 GMT

A small subset of my schema looks as follows:

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?

Re: Date..From/To selection using Set Analysis

Gysbert_Wassenaar — Thu, 04 Jul 2013 12:06:44 GMT

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

topic Date..From/To selection using Set Analysis in QlikView

Date..From/To selection using Set Analysis

Re: Date..From/To selection using Set Analysis