2 Replies Latest reply: Jun 17, 2014 10:16 AM by Giuliano Torelli RSS

    Only customers appearing in the same period. How?

      Hi.

      I'm moving my very first steps with Qlik.
      I have a table with these info:

      - Transaction date (from jan 2013 till mar 2014).

      - Customer ID

      - Store ID

      - Value

       

      My draft dashboard allows to select months and/or weeks to show comparison Values for 2013 and 2014.

       

      How can I show comparison values just for the customer IDs which have at least a transaction in both periods?

       

      Thank you very much in advance.

       

      G

        • Re: Only customers appearing in the same period. How?

          Could you share a sample qvw?

            • Re: Re: Only customers appearing in the same period. How?

              Hi Robert,

              I'm not able at the moment but I can share some data with you.

               

              Transaction dateCustomer IDStore IDValueYearMonthWeek
              01/02/20131232120201325
              26/02/20131231150201329
              23/03/201354621442013312
              17/04/201345621242013416
              12/05/201345611302013520
              06/06/201378921222013623
              01/07/201378921162013727
              26/07/201312311022013730
              20/08/201312311492013834
              14/09/201312321372013937
              09/10/2013123214420131041
              03/11/2013456211420131145
              28/11/2013456214720131148
              23/12/2013879114320131252
              17/01/20144562124201413
              11/02/20144562126201427
              08/03/201478921252014310
              02/04/201478911222014414
              27/04/201412311342014418
              22/05/201412321072014521
              16/06/201412321022014625
              11/07/201412311432014728
              05/08/201445611142014832
              30/08/201478911462014835
              24/09/201478911122014939
              19/10/2014123110520141043
              13/11/2014123212420141146
              08/12/2014123113620141250

               

               

              If i choose Month = 2, I should have a result like this:

               

              20132014
              Store IdHow many customers?ValuesHow many customers?ValuesAppearing in the same period?Values AITSP
              111500000
              21120112600
              Totale complessivo2270112600

               

               

               

              If I choose Month = 7

               

              20132014
              Store IdHow many customers?ValuesHow many customers?ValuesAppearing in the same period?Values AITSP
              11143001143
              222180000
              Totale complessivo221811431143