2 Replies Latest reply: Sep 1, 2012 5:06 AM by Kusumajaya Na RSS

    Unselected Parameter Expression

    Kusumajaya Na

      Hi,

       

      I'm new to qlikview and I would like to ask about parameter and expression.

       

      PeriodCost
        21,070.34
      1-Jan-12  38,008.46
      1-Feb-12  24,446.99
      1-Mar-12  16,234.31
      1-Apr-12  24,148.52
      1-May-12  13,229.94
      1-Jun-12  17,093.20

       

      The above table is the sample data I'm working on. 

      I set to Load Month(Period) as Month.  I put it as Selectable Fields.

       

      Month
      Jan
      Feb
      Mar
      Apr
      May
      Jun

       

      If I select Jan, then 38,008.48 will be selected on my table.  My question is how can I set an expression if I did not select any month, then the 21,070.34 appear on my table, and if I select any month, then the number under cost will be selected.

       

      Thank you in advance.