topic Re: Select data FROM - TO in QlikView

Select data FROM - TO

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

We have date column named 'Report_Date' contains dates. I have 2 list boxes / calendar to select FROM - TO date and show result on basis of selection. Requirements are :

1. user can select date intersection of 2 months. Ex. 10-Apr-17 to 5-May-17.

Please guide me on this, Thanks in Adv

Re: Select data FROM - TO

micheledenardi — Fri, 16 Jun 2017 06:26:46 GMT

You can use different method to select multiple date:

1) Single listbox and select single date or data range;

2) 2 different listbox setted with 2 different date fields and then use SetAnalysis in your expressions like:

sum({<Date={">=$(=min(MinRefDate))<$(=max(MaxRefDate))"}>}Sales)

3) Use the default QlikView calendart object with a single date field:

Hope it helps

Re: Select data FROM - TO

Anil_Babu_Samineni — Fri, 16 Jun 2017 06:34:32 GMT

Just to add few inputs

1) We have to create 2 variable like

i) MinRefDate = MonthYear(Min(DateField),'MMM YYYY')

ii) MaxRefDate = MonthYear(Max(DateField),'MMM YYYY')

2) Here, we need to validate or choose the variable to calendar object.

3) Next is Michele points can help you

Re: Select data FROM - TO

prma7799 — Fri, 16 Jun 2017 06:41:58 GMT

Please check this also

Slider/Calendar Object ‒ QlikView

Selecting Arbitrary Date Ranges

Re: Select data FROM - TO

Kushal_Chawda — Fri, 16 Jun 2017 06:57:02 GMT

see this

From Date & To Date Selection in Data