5 Replies Latest reply: Sep 19, 2017 9:01 AM by Naseem Saadeddine RSS

    How to get this month and last month sales total within a KPI measure

    Naseem Saadeddine

      Hello all,

       

      I run a small store and I am new to qlick cloud.

       

      I want to create a KPI that calculates total sales of current month in a separate measure and last month in another measure.

       

      sample table as following

       

      InvoiceDateInvoiceTotal
      9/15/2017100
      9/15/201755
      9/12/201722
      9/5/201788
      8/25/201782
      8/15/201742
      8/12/201755
      8/8/201775
      8/2/201718

       

      using dimensions with in charts and tables its easy but I cant figure out how to do this in a KPI chart