Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Partner - Master III
Partner - Master III

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)

Anonymous
Not applicable
Author

No

in fact I want to select a period of activity.

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

shraddha_g
Partner - Master III
Partner - Master III

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.

Anonymous
Not applicable
Author

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
Partner - Master III
Partner - Master III

If you are using 2 filters then you can try

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

arulsettu
Master III
Master III

may be in calendar create field like

day(date_field) as day

and use it as filter