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

    Qlikview expression question: a calculation of another expression

    Yuehan Guo



      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.











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