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

Filter for date

Hi all,

I have an ordered date which I wish to create a filter on.

The filter should be as follows:

  • This week
  • Last week
  • This Month
  • Last Month
  • Last 3 months
  • Last 6 months
  • This year.

I cannot create a single dimension field for all this, the reason being it won't select all I need.

For ex: If I select this month, then it should select the components of "This Week" as well.

Could someone please give me a direction as to how I should go about this?

20 Replies
jmvilaplanap
Specialist
Specialist

Is the same, you can add buttons with the trigger "Selection -> Select in Field" and use this expressions for filter. And when the user clicks on "Last Week", apply the filter flag_lastWeek equals to 1.

Anonymous
Not applicable
Author

Could you elaborate this please?

Or give me an example qvf? Sounds interesting.

Anonymous
Not applicable
Author

Thanks Ivan. However it only has a few selections.

Doing something on our own will mean endless possibilities which is what I am aiming for.

Ivan_Bozov
Luminary
Luminary

You could also assign custom ranges with the Climber Selection Bar. But of course, use whatever is best for you.

screenshot_date_range_picker.PNG?raw=true

vizmind.eu
ahaahaaha
Partner - Master
Partner - Master

Hi,

Look attached file

jmvilaplanap
Specialist
Specialist

Capture.PNG

This is a capture of Qlikview, but I think will be the same in QlikSense, you can add a trigger to an object (in this case a Text Object) and when you click it, this selection is made.

Anonymous
Not applicable
Author

Ah, okay. I am working on Qlik Sense.

So I think I will have to make use of an extension for this. This feature is not available in Qlik Sense by default.

jmvilaplanap
Specialist
Specialist

Yes, this solution is not valid for QS, I'm sorry. You would use an extension (or find a workaround)

good luck!

Anonymous
Not applicable
Author

Thanks.

Trying with this approach and the below extension. Will let you know how I fare:

Qlik Branch

Thanks Jose Miguel.

Regards,

SS.

Anonymous
Not applicable
Author

Thanks, will check it out & let you know.