topic Qlikview between dates filter in QlikView

Qlikview between dates filter

Sun, 22 Apr 2012 15:04:05 GMT

Hi,

I have a report in which I have a date field processed date. I want to create a calandar object, where the user can select a start date, end date and the filter should be applied based on the range between start date and end date. At the moment, If I select a date, the report shows data for that date. However, I want to update this calandar so that the user can select a start date and end date and the chart should show data between those two dates. What is the function or method to acheive this functionality

Regards

Arif

Qlikview between dates filter

jonathandienst — Sun, 22 Apr 2012 16:23:14 GMT

Arif

One way to do this is to define two variables (assuming you have a date field called Date):

vMinDate: =Min(Date)
vMaxDate =Max(Date)

The use set analysis in the expressions to limit the data between these two dates. For example:

Sum({<Date = {">=$(=Date(vMinDate)) <=$(=Date(vMaxDate))"}>} Sales)

If you have other date related fields linked to Date (such as Month, Year), you may need to override their selection with

Sum({<Date = {">=$(=Date(vMinDate)) <=$(=Date(vMaxDate))"}, Year=, Month= >} Sales)

Regards

Jonathan

Re: Qlikview between dates filter

jonathandienst — Sun, 22 Apr 2012 17:12:54 GMT

The attached example illustrates this