Controlling Date Selection in QlikView

Qlik Technical Article

Article sections

    Summary: Quick guide on controlling date selection in QlikView
    Article Type: Support/Troubleshooting
    Related Product: This article relates to the following products:

    • QlikView
     Related Articles:

     

    Scenario

    When using QlikView, the predominant means for users to filter the data is via list boxes.  There are some instances where providing the list boxes to accommodate the date range selections will not work.

    For example trying to select all vehicle hires from 20/12/2014 to 10/1/2015 in the document below is problematic.  The selections below do not equate to that date range.

    kb1

    The only solution with a selection box would be the date itself.

    kb2

    kb3

    But the date list box itself will become cumbersome to use if you are trying to select a large date range.

     

    Solution

    Provision of a Start and End Date selection will allow for a simpler interaction with the document.

     

    kb4

    Each date should be linked to a variable which can then be used in set analysis expression.

    As a safeguard you can stop the users making an end date selection prior to the start by setting the start of End Date calendar to be the variable for Start Date.

    kb5

    Related Information:
    in GeneralQlikviewSupportTroubleshooting
    Share This Post
    Share on facebook
    Share on linkedin
    Share on twitter
    Share on email
    More To Explore

    Ready to Talk about your Project?
    Book a free Discovery Call

    A no obligation call to discuss your business needs and project requirements. During the call, our consultant will explain how we can help you to achieve your goals and answer any questions you may have.