4 Replies Latest reply: Jun 20, 2013 11:29 AM by Yuehan Guo RSS

    Qlikview expression question: a calculation of another expression

    Yuehan Guo

      Hi,

       

      I'm new to Qlikview application development and I need some help on writing an expression.

       

      I was trying to add a second expression where it calculates the % of each cost category as of Premium (Please see the example table below). But I can only get a 100% for the premium line, which is correct, but 0 for the costs. I'm not farmilar with the set analysis so I guess something got messed up there....

       

      Can someone help me with this? Your help is highly appreciated.

       

      Thanks!

       

      Renee

       

      Sum(NET_AMOUNT)/Sum({$<Bar_line={1}>}NET_AMOUNT

      )

       

       

      Bar_Line

      NET_AMOUNT% as of Premium
      1 (represent Premium)$100100%
      2 (represent Cost1)$30- (should be 30%)
      3 (represent Cost2)$40- (should be 40%)