Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Between Date Filter

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

9 Replies
Gysbert_Wassenaar
Not applicable

Re: Between Date Filter

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

Not applicable

Re: Between Date Filter

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

Not applicable

Re: Between Date Filter

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

galax_allu
Not applicable

Re: Between Date Filter

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
Not applicable

Re: Between Date Filter

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

h_eskelinen
Not applicable

Re: Between Date Filter

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.

Not applicable

Re: Between Date Filter

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

okolyug16
Not applicable

Re: Between Date Filter

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

Capture.PNG

cwk
Not applicable

Re: Between Date Filter

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

Qlik Branch 

Carson