Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jonathan_ineox
New Contributor III

Date Filter

I created a calendar, and I added a filter in my application with the dates of this calendar.

I wish use calendar dates as a filter for my data.

For example if the user chose the 01/01/2017 I have the sales of 01/01.

How do I proceed?

I think I have to use a variable but I do not know how

Someone can help me please ?

6 Replies
shraddha_g
Honored Contributor III

Re: Date Filter

What is the issue you are facing?

Do you want to display Sales of that selected Date?

Then you can try

Sum({<Date = {"$(=Max(Date))"}>} Sales)

jonathan_ineox
New Contributor III

Re: Date Filter

No

in fact I want to select a period of activity.

Example: Sale between 01/01/17 - 03/03/17

shraddha_g
Honored Contributor III

Re: Date Filter

in Filter , you can search >=01/01/17<=03/03/17 and press Enter.

It will select all dates in between those 2.

Make sure that you give input in correct date format.

jonathan_ineox
New Contributor III

Re: Date Filter

It's a very good idea.

But I wanted to use two filters StartDate, EndDate.

I will offer it to my manager if I can not find it.

shraddha_g
Honored Contributor III

Re: Date Filter

If you are using 2 filters then you can try

Sum({<Date = {">=$(=Max(StartDate))<=$(=Max(EndDate))"}>} Sales)

arulsettu
Honored Contributor III

Re: Date Filter

may be in calendar create field like

day(date_field) as day

and use it as filter

Community Browser