Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ipsitafujitsu
New Contributor

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

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

Tags (1)
5 Replies
drillnaut
Valued Contributor

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

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
New Contributor

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

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
Esteemed Contributor

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

If your date field is date:

do as follow:

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

omarbensalem
Esteemed Contributor

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

Per analogy :

I select tranID 9 and 14

and my expression is :

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

I'll have :

Capture.PNG

ipsitafujitsu
New Contributor

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

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