6 Replies Latest reply: Mar 14, 2017 7:45 AM by Sunny Talwar RSS

    Qlik sense -Q1 Variance % is Showing Blank

    joshi Babu Are

      Hi Guru's,

       

      Iam finding QoQ Variance % in Pivot Table.

       

      iam able find the Variance % for Q2,Q3,Q4 ,Since there is no Previous Quarter for Q1 So its Showing Blank.

       

      But i have a requirement that it should Consider Last Year Q4 As Previous Quarter.

       

       

      Ex:if i Select 2017.it should Consider 2016 Q4 Minus  2017 Q1 Difference in 2017 Q1 QoQ variance

       

      Please find the App and Excel File as Attached.

       

      Dynamic Expression Would be the solution ,how to Write?

       

      any help would be greatly appreciated.

       

       

      Thanks,

      Joshi