topic Re: Date Filter in QlikView

Date Filter

Tue, 04 Dec 2012 13:21:56 GMT

I am providing date range filters in the front end so that the data in the reports i.e straight table or pivot table filters out & only show the data which is in between the date range. but the data is not getting filtered rather it is showing it as full. please help how to filter out the data.

here is the attachement of the file as per this when we select any date range data should be only for that specific range for booking date & travel date. but when we select any date range data didn't filters out rather it shows full data . Please help.............

Re: Date Filter

Tue, 04 Dec 2012 15:05:43 GMT

Hi Manish,

I can't find any link between your Variables (vBookingFromDate, ...) and the according date fields you used as dimensions in your chart. So nothing will happen (this is correct) when selecting another value for your variable(s).

May be a calculated dimension will help you, similar to:

=if(date($(vBookingFromDate)) >= [Booking Start Date], [Booking Start Date])

instead of the simple dimension "[Booking Start Date]"

Same for "[Booking End Date]"

Don't forget to check "Supress When Null" for these dims.

HtH

Roland

Re: Date Filter

Thu, 06 Dec 2012 05:52:04 GMT

hey,

this expression is not working. when i apply this expression the values comes out to be null

Re: Date Filter

Thu, 06 Dec 2012 08:44:19 GMT

Hey,

the expression worked fine when I tested it in your app. If you get only null-values, pls check syntax.

Re: Date Filter

Gysbert_Wassenaar — Thu, 06 Dec 2012 10:55:00 GMT

See attached qvw. You were missing actions on the variable triggers.

Re: Date Filter

Thu, 06 Dec 2012 11:55:50 GMT

hey

when i copied this report in my application it's not working. I discovered that you had only added "{1}" in all the fields.

Can u guide what might be the reason for not working. or what else change you have done.

Re: Date Filter

Thu, 06 Dec 2012 18:40:18 GMT

Hey Gysbert

Thanks for the help.