7 Replies Latest reply: Dec 11, 2012 5:23 AM by sujeet singh RSS

    Input Box

      Hi All,

       

      I'm currently exploring the capabilities of the input box of qlikview.

      Here are my objects and fields:

      1. Input box

      2. List box: Month,Year

      3. Pivot or Straight Table: Values

       

      Input box/field = [input number]

      Month = Jan, Feb, March, ..., Dec

      Year = 2011, 2012

       

      Table:

       

      DateValueInput Field
      1/2/201110x
      2/2/20113x
      4/1/20125x
      5/2/20125x

       

      Is it possible if I select a Mont [March], and then I input in the Input box = 5

      It will populate only 5/2/2012 in the input field with the value 5.'

       

      And let's say it is month end for a specific date, the inputted fields will be locked

      and only the dates up to date are the only one can be edited.

       

      Thanks =)

       

      -Donna