How to achieve relative date range filter in QlikView?

[Anonymous]

Hi qlik,

can any help me on achieving the relative date filter in QlikView.

Above relative date filter achieved in Tableau just like that i want same filter type in QlikView. Is it possible to achieve?

hic‌sreerangasane‌loveisfail‌swuehl‌rwunderlich‌filip_duchateau‌stalwar1‌stevedark‌

[prma7799]

Use calendar object for this

Slider/Calendar Object ‒ QlikView

Selecting Arbitrary Date Ranges

[stevedark]

Hi Vandith,

There is no native object in QlikView for doing this, but you can quite easily construct something similar.

Take a look at my post on buttons in QlikView on how you can create toggles and buttons to increment values:

https://www.quickintelligence.co.uk/qlikview-buttons/‌

This app shows how you can set start and end dates using buttons and actions:

QlikView App: Using Actions To Change Date Variables

You will need to have a number of variables (IntervalType, InvtervalNumberEnd, IntervalNumberStart) and then date calculations to go from today to where you need to be, something like:

vEndDate

=if(vIntervalType = 'Day', today() + vIntervalNumberEnd,

  if(vIntervalType = 'Week', today() + (vIntervalNumberEnd * 7),

  if(vIntervalType... etc...

You may also want to do some show/hide stuff to pop up the dialog when you need it, as it will take a lot of space up otherwise.

Good luck!

Steve

[Anil_Babu_Samineni]

You have to do many things to achieve this in Qlikview. Even though we don't have radio button functionality if you would like go for work around, Yes there is widget by help of HTML. and now you are talking about many objects from one-many

Finally, We would look to related hide and show objects by help of variables like Steve mentioned in above. Here, We require to qualify and need to be done in Validation to check those and that you need automatic data while selection happened. Here, I would love to know few things from Steve and I've done this earlier when i was stuck in same scenario and i done trouble shoot fir it. Here, please please provide information related the same so that we can have a look. That would really help to think better rather than simple context

[rwunderlich]

Take a look at this example for an idea.

Qlikview Cookbook: Date Grouping http://qlikviewcookbook.com/recipes/download-info/date-grouping/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com