2 Replies Latest reply: Jan 4, 2017 11:22 AM by s Walter RSS

    How to compare records

    s Walter

      Hi,

       

      i want to show in a combi chart the

       

      1. Sum of "Kunde" (Customer) per month
      2. Each new record per month
      3. Each lost record per month

       

      Example:


      Each new record per month:

      Each record wich have the current date of the month and is not existing the month before

      In Aug are 4 new records


      Each lost record per month:

      Each record existing the month before, but not in the current month

      In Aug are 3 lost records


      4 records already exist. The sum in Aug is 8.


      This table is only for help to understand new, lost and exist, i use a table wich has only the columns from a to d.

      qlik-sense-new-lost.jpg

      How can i compare the data to show the number of new and lost records per month?


      qlik-sense-chart.jpg


      regards,

      sam


        • Re: How to compare records
          Allu Allu

          may be like  this

           

           

          Month(Date#(Day, 'MM/DD/YYYY')) as Month



           

          1. Sum of "Kunde" (Customer) per month

           

          aggr(count (kunde),Month)   //Where Month derived from your tbDatum.

           

          2. Each new record per month

           

          aggr( count (  { < new={"x"}  >}Kunde),Month)  //Where Month derived from your tbDatum.

           

          3. Each lost record per month

           

           

          aggr( count (  { < Lost={"x"}  >}Kunde),Month) //Where Month derived from your tbDatum.

            • Re: How to compare records
              s Walter

              Hi, thanks for your help.

               

              This table is only for help to understand new, lost and exist, i use a table wich has only the columns from a to d.

               

              I use this table:

              2017-01-04_17h17_44.jpg

              I search for a solution to work only with this table.

               

              regards,

              sam