Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Add a filter pane with the two fields. Then make selections in the fields.
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
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
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)
No, they're two different fields. How do you expect two fields to behave as a single field?
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.
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
Maybe try typing in the date range within the filter, using >=date1 <=date2 should give you all dates within the dates 1 and 2.
you can also use an Extension in Qlik - a Date Range picker for example - have a look.
Carson