0 Replies Latest reply: May 4, 2012 12:53 AM by Bill Ringer Salalima RSS

    Is possible to use applymap?

      Hi,

       

      is there a way to use apply map or function in qlikview, rather than using nested if statement..

       

      ITEMS     UNIT PRICE     CLASS

      A               10,000          LAPTOP

      B               13,000          LAPTOP

      C               16,000          LAPTOP

      D               10,000          HOUSE

      E               25,000          HOUSE

       

      So I have intervals

       

      For Class LAPTOP:

           Intervals          Minimum          Maximum

           5K Interval          10,000               15,000

           5K Interval          15,001               20,000

       

      For Class HOUSE

           Intervals          Minimum          Maximum

           10K Interval        10,000               20,000

           10K Interval        20,001               30,000

       

      So, just wanna ask if i can use applymap function to these, or simply still use the nested if, so that I could have this report

       

       

      ClassIntervalItem
      Laptop5K IntervalA


      B


      C
      House10K IntervalD


      E

       

      How? Please help.