topic Date Filter Based on Field selection in QlikView

Date Filter Based on Field selection

Kushal_Chawda — Tue, 11 Dec 2012 11:43:25 GMT

Dear All,

I have 3 date fileld Date1, Date2, Date3.

I am creating inline table as

load * inline [

Filed

Date1,

Date2,

Date3,

];

There is two calender objects to select FromDate to ToDate. I am using button to apply Date filter.

My requirement is,

When I select Date1 with FromDate & ToDate from calender and click on Apply filter button den data should be filtered from Date1 field and also should reflect on chart.

similar action should happen when I select Date2 and so on.

Regards,

Kush

Re: Date Filter Based on Field selection

Miguel_Angel_Baeyens — Tue, 11 Dec 2012 11:46:57 GMT

Hello Kush,

You a variable instead in the calendar object, as in this application, then use a set analysis in the chart expressions to limit results to those dates.

Hope that helps.

Miguel

Re: Date Filter Based on Field selection

sujeetsingh — Tue, 11 Dec 2012 11:50:07 GMT

Just a simple and to the point answer by Miguel!!!!

Re: Date Filter Based on Field selection

Kushal_Chawda — Tue, 11 Dec 2012 12:38:36 GMT

Hi Miguel,

Thanx for the quick reply... I got your point But can you tell me how can I filter the dates by selecting the other date field.

I have 3 date fieds.

Re: Date Filter Based on Field selection

Miguel_Angel_Baeyens — Tue, 11 Dec 2012 12:51:30 GMT

Hi,

Create a new variable called vDateFieldName that stores

=GetFieldSelections(Filed)

So when you call at $(vDateFieldName) the name of the field selected from those three is in the variable, therefore comparing to the selected date field.

Hope that helps.

Miguel

Re: Date Filter Based on Field selection

Kushal_Chawda — Wed, 12 Dec 2012 06:11:27 GMT

In attached file I have explained what I need is.

Actually I wan to do it in that way only but not getting.

Regards,

Kush

Re: Date Filter Based on Field selection

Kushal_Chawda — Thu, 13 Dec 2012 05:11:14 GMT

Hi Miguel,

Finally i got the solution after trying hard.

Re: Date Filter Based on Field selection

Miguel_Angel_Baeyens — Fri, 14 Dec 2012 07:49:58 GMT

Hi,

Glad to know. The only change you need is modifying the field in the action of the button to

=GetFieldSelections(DateType)

So it will apply the selections in the variables to the date field selected.

Hope that makes sense.

Miguel

Re: Date Filter Based on Field selection

Kushal_Chawda — Fri, 14 Dec 2012 08:39:47 GMT

Thnx Miguel..

Only difference I made is I have used variable in Action..