Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

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
JustinDallas
Valued Contributor II

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 III

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.

Partner
Partner

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)

Partner
Partner

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

Partner
Partner

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