3 Replies Latest reply: Oct 20, 2017 5:17 PM by Chaitanya Moparthi RSS

    Filter data in Qlik Sense Table

    Chaitanya Moparthi

      Hi,


      I have a simple query which you can answer.


      I have a table


      Date                           Customer_Name          Purchase_count


      10-09-2017                John                              430

      10-09-2017                Ryan                              400

      10-09-2017                Martin                          200

      11-09-2017                John                              450

      11-09-2017                Ryan                              400

      11-09-2017                Martin                          580

      12-09-2017                John                              700

      12-09-2017                Ryan                              300

      12-09-2017                Martin                          210


      I want to display 2 KPI values for 'Martin' for 2 different periods.


      KPI 1:           Period 1 Purchase count for Martin(This Month)        :          Sum of all days Purchase_count for this month


      KPI 2:           Period 2 Purchase count for Martin(Last Month)        :          Sum of all days Purchase_count for last month


      Can any one please help me with the expression which I can use to filter this data.


      Please never mind if this is an easy question. Thanks.