Between Date Filter

[#1]

Hi

I am using Qlik Sense.

I have 2 date fields.

Start_Date and End_date.

How can i create between prompt.

Thanks

Govind R

[Gysbert_Wassenaar]

Add a filter pane with the two fields. Then make selections in the fields.

[#3]

My values like startDatetime and EndDatetime

I have to select

e.g  Jan-2016 instead of 1-jan-2016 How can i achieve month and year only.

Is there any other function like select start date and end date using calendar formate in qlik sence.

Thanks

Govind R

[#4]

I achive using below command

=Date(monthstart(ACT_END_DATE), 'MMM-YY')

Is it possible calendar selection formula ?

If i select both field in single prompt selection,Is it work Between rage ?

THanks

[Anonymous]

Hi

you  can try like this...

add a filter pane1;

=Date(monthstart(ACT_END_DATE), 'MMM-YY')

add a filter pane2:

=Date(max(ACT_END_DATE), 'MMM-YY')        //or  (=Date(monthend(ACT_END_DATE), 'MMM-YY')

and use set  analysis in PIVOTTABLE or STRAIGHT TABLE  like below;

sum(  {  < ACT_END_DATE={">=$(=Date(monthstart(ACT_END_DATE), 'MMM-YY'))<=$(=Date(max(ACT_END_DATE), 'MMM-YY') )"}  >  } sales)

[Gysbert_Wassenaar]

No, they're two different fields. How do you expect two fields to behave as a single field?

[Anonymous]

As Gysbert said above, you will have to use separate filter panes for the start and end dates. If you want to filter by start and end months, I would suggest creating separate fields for those in the load script. Below is an example of how that could look like:

Month(startDatetime) & '-' & Year(startDatetime) as StartMonthYear

Month(EndDatetime) & '-' & Year(EndDatetime) as EndMonthYear

Then you create filter panes for StartMonthYear and EndMonthYear.

[#8]

Hi All

Thanks a lot.till not able to achieve.

I need to select my filter in between range not one by one.

In this case if i select any one filter also it will display my data instead of that i have to choose both start and end then only my data should display.

Thanks

[Anonymous]

Maybe try typing in the date range within the filter, using >=date1 <=date2 should give you all dates within the dates 1 and 2.

[Anonymous]

you can also use an Extension in Qlik - a Date Range picker for example - have a look.

Qlik Branch 

Carson