3 Replies Latest reply: Jun 5, 2018 5:12 AM by Thomas Ake RSS

    Input box with Predefined values

    Thomas Ake


      Hi ALL,

      anybody an idea how to do that in QlikSense:

      Input box with Predefined values coming from a ... | Qlik Community

       

      We need a inputbox with two variable (vStartdate- and vEnddate) as drop-down with semicolon separated predefined values.
      In QlikView this is straightforward with "Input Box" with settings in "Constraints" tab:


      At the end we want do calculations base on a certain period (vStartdate and vEnddate) what is selected by the users.
      Input box with drop-down list in Qlikview looks like this here:

       

       

      Our expression will be look like this:
      sum({<Salesdate={">=$(vStartdate_FromDate<=$(vEnddate_ToDate)"} >} Sales)

       

       


      Thx in advance.
      Thomas