1 Reply Latest reply: Mar 1, 2016 2:09 PM by Stefan Wühl RSS

    Is this feasible in QlikSense?

    Kishore Kumar

      Hello All,

       

      I have a peculiar requirement which is described below. Could anyone help with your inputs/suggestions.

       

      Requirement: I am looking to have two time series overlaying each other on one chart. Requirement is to show meetings from one quarter and the sales from the following quarter to be on top of each other.  In other words, did the work I did last quarter impact sales this quarter.

       

      Regards,

      Kishore

        • Re: Is this feasible in QlikSense?
          Stefan Wühl

          Maybe use a calculated dimension like

           

          =daynumberofquarter( DateField)

           

          and two expressions, something along these lines

           

          =Count( If( InQuarter( DateField, Today(), -1), Meeting))

          =Sum( If( InQuarter( DateField, Today() ) , Sales))

           

          you may also use set analysis to restrict your records to specific quartes per expression.