How to get the filter result for a selected range of Date.

[Ipsita]

Hello Team ,

I have started using Qlik sense few months back so i will need your help in framing one of my report.

I will need to have result like, list of customers based on selected range of their registration date.

For example, if I will select one filter date as 11/05/2016 and another date as 30/10/2016, then i should get the result as the list of customers those who have registered between the date 11/05/2016 to 30/10/2016.

I am using ODBC and SQL Db string as my data connection.

Could you please help me how to achieve this.

One more query I have, do we have any option of calendar date picker in Qlik sense. I guess it is possible in qlik view but i am not sure about how to get calendar in Qlik sense.

Regards,

Ipsita

[JustinDallas]

I know this isn't helpful, but you've got about 2 or 3 problems wrapped into one question.  Creating the list and the filter has nothing to do with your ODBC or SQL connection.  Can your app get data from the DB?

[mananmehta900]

Hi Ipsita,

Following is the URL (all references included for copyrights if any required) for date range picker extension.

Once you implement this, apply the filter based on registration date (in the extension properties) and you should be able to see the filter automatically applied for your customers based on dates selected.

customer.

Qlik Branch

Thanks.

[OmarBenSalem]

If your date field is date:

do as follow:

sum({<date={">=$(=min(date)) <=$(=max(date))"}  >}YourExpression)

[OmarBenSalem]

Per analogy :

I select tranID 9 and 14

and my expression is :

Sum({<TransID={">=$(=min(TransID)) <=$(=max(TransID))"}  >}Expression1)

I'll have :

[Ipsita]

Yes, my app get data from DB.

I need filter to select two dates and want the results of records in between that selected Dates.

Current I am filtering according to only Dates or Months and getting results based on the selected dates or months but not in between the dates.

Regards,

Ipsita