1 Reply Latest reply: Oct 31, 2017 7:31 PM by Luis Madriz RSS

    Qliksense: Need YTD and Variance column in pivot  table with multiple measures

    sandeep kumar

      Need help to create this view in Qlik Sense Pivot table. Sample data is attached in the excel

              

      Prior MonthsCurrent MonthYTDYoY%
      Jun-17Jul-17Aug-17Sep-17BudgetVarianceSep-17Sep-BudgetVarianceSep-16Sep-16 v Sep-17YTD 16 v YTD 17
      Con10405090110-20200210-10540-45%-63%
      Churn520254555-1070155-85270-21%-74%
      Upgrd624305466-1290166-76324-27%-72%

       

      This seems similar in approach to solution mentioned in below blog. However I am new to QlikSense and not able to adjust this to my requirement.

       

      Qliksense: Need YTD column in pivot  table

       

      stalwar1