10 Replies Latest reply: Feb 16, 2016 9:56 AM by Kaushik Solanki RSS

    Difference Between Actual and Plan

    Weng Cheun Fong

      Hi, I am a newbie trying out Qlik Sense. My dataset consists of month, year, sales amount, actual or plan indicator.  For example,

      Month      Year      Sales Amount     Act_Plan

      1               2016     1000                    Actual

      1               2016     1100                    Plan

      2               2016     1200                    Actual

      2               2016     1300                    Plan

       

      Queries:

      1. How do I create a measure to show the difference between Month Actual less Month Plan?

      2. If I want to chart this, how do I show the Sales Amount for Actual and Plan side-by-side?

       

      Thank you.